SQL server 2005
I did a backup for application database: testdb
I re-created the master db with setup.exe
I created a new database testdb
I want to restore the backup of testdb
when I did I have the following message ...
The backupset holds a backup of a database other than the existing 'testdb'
database
Re: Locate T-SQL Referenced by Job Step? ... I tend to do backup and restore operations while being in the master database.... Its essentially telling the SQL Server to run a transaction log backup of myDB and send the results to the backup device named myDBBackup. ... The job step uses parameters to reference the T-SQL command, e.g. the name of the database within which the command resides, and the command to be run. ... (microsoft.public.sqlserver.server)
RE: SQL Server failing to start (directly effecting sales!!!) Error: 823, Severity: ... You should consider calling Microsoft Technical Support as your master... They will want your SQL Server Errorlogs... that the machine with the database has hardware that is failing. ... Even if you are planning to reinstall you should make a backup copy ... (microsoft.public.sqlserver.msde)
Re: Differential backup of "master" failing ... The reason is stated explicitly in the error message: you can only perform a full backup of the master database.... Is there some reason I cannot do a differential backup of the master db even though it was an option in the wizard? ... (microsoft.public.windows.server.general)
Differential backup of "master" failing ... I used the wizard to create a daily differential backup and selected "All ... this is failing on the "master"... Use BACKUP DATABASE to back up the entire master ... Is there some reason I cannot do a differential backup of the master db even ... (microsoft.public.windows.server.general)
Re: Differential backup of "master" failing ... a full backup of the master database.... Why the wizard allowed you to choose master in the first place is beyond ... (microsoft.public.windows.server.general)
