Guest Bill Fuller Posted January 9, 2008 Posted January 9, 2008 I used the wizard to create a daily differential backup and selected "All Databases" in the dropdown. However, this is failing on the "master" database.with the following error: Executing the query "BACKUP DATABASE [master] TO DISK = N'F:\\Data\\Databases\\SQL\\MSSQL.1\\MSSQL\\Backup\\master_backup_200801091427.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'master_backup_20080109142730', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database. BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Is there some reason I cannot do a differential backup of the master db even though it was an option in the wizard?
Guest Aaron Bertrand [SQL Server MVP] Posted January 9, 2008 Posted January 9, 2008 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. This is because master is in simple recovery mode, period. Why the wizard allowed you to choose master in the first place is beyond me. Maybe related to this bug: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=320914 I assume this is SQL Server 2005, if so, is it up to date? SP2 + post-SP2 hotfixes? "Bill Fuller" <someone@nospam.com> wrote in message news:%235XZDHxUIHA.4768@TK2MSFTNGP02.phx.gbl... >I used the wizard to create a daily differential backup and selected "All >Databases" in the dropdown. However, this is failing on the "master" >database.with the following error: > > Executing the query "BACKUP DATABASE [master] TO DISK = > N'F:\\Data\\Databases\\SQL\\MSSQL.1\\MSSQL\\Backup\\master_backup_200801091427.bak' > WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = > N'master_backup_20080109142730', SKIP, REWIND, NOUNLOAD, STATS = 10 > > " failed with the following error: "You can only perform a full backup of > the master database. Use BACKUP DATABASE to back up the entire master > database. > > BACKUP DATABASE is terminating abnormally.". Possible failure reasons: > Problems with the query, "ResultSet" property not set correctly, > parameters not set correctly, or connection not established correctly. > > > > Is there some reason I cannot do a differential backup of the master db > even though it was an option in the wizard? > >
Guest Bill Fuller Posted January 10, 2008 Posted January 10, 2008 Re: Differential backup of "master" failing Hmmmm... it seems that the wizard should bypass any database that is in "simple" recovery mode when all databases are selected. Thanks... Good to know. "Aaron Bertrand " <ten.xoc@dnartreb.noraa> wrote in message news:eUb%23RrxUIHA.5300@TK2MSFTNGP03.phx.gbl...[color=blue] > The reason is stated explicitly in the error message: you can only perform > a full backup of the master database. This is because master is in simple > recovery mode, period. > > Why the wizard allowed you to choose master in the first place is beyond > me. Maybe related to this bug: > > https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=320914 > > I assume this is SQL Server 2005, if so, is it up to date? SP2 + post-SP2 > hotfixes? > > > > > > > "Bill Fuller" <someone@nospam.com> wrote in message > news:%235XZDHxUIHA.4768@TK2MSFTNGP02.phx.gbl...[color=green] >>I used the wizard to create a daily differential backup and selected "All >>Databases" in the dropdown. However, this is failing on the "master" >>database.with the following error: >> >> Executing the query "BACKUP DATABASE [master] TO DISK = >> N'F:\\Data\\Databases\\SQL\\MSSQL.1\\MSSQL\\Backup\\master_backup_200801091427.bak' >> WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = >> N'master_backup_20080109142730', SKIP, REWIND, NOUNLOAD, STATS = 10 >> >> " failed with the following error: "You can only perform a full backup of >> the master database. Use BACKUP DATABASE to back up the entire master >> database. >> >> BACKUP DATABASE is terminating abnormally.". Possible failure reasons: >> Problems with the query, "ResultSet" property not set correctly, >> parameters not set correctly, or connection not established correctly. >> >> >> >> Is there some reason I cannot do a differential backup of the master db >> even though it was an option in the wizard? >> >>[/color] > [/color]
Recommended Posts