Differential backup of "master" failing

  • Thread starter Thread starter Bill Fuller
  • Start date Start date
B

Bill Fuller

Guest
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?
 
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?
>
>
 
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 [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:eUb%23RrxUIHA.5300@TK2MSFTNGP03.phx.gbl...
> 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?
>>
>>
>
 
Back
Top