0

I am running SQL Server 2008 R2 Standard Edition on a Windows Server 2008 R2 Enterprise. I'm using the standard backup and restore for the server portion and the native SQL Backups for the databases.

I want to exempt the Transaction Log and Data File Directories from the Server backup because I am taking SQL Backups and I don't want to waste space backing up the same objects twice.

However, SQL Server cannot start without the Master database (and perhaps others as well). What's the best process/solution for this?

DavidStein
  • 153
  • 1
  • 5

1 Answers1

1

Just back up the master and msdb databases too, same way you do the user databases. You can restore them as well:

http://msdn.microsoft.com/en-us/library/ms190190.aspx

Brent Ozar
  • 4,425
  • 18
  • 21