April 11, 2007 at 10:01 pm
how do i take a backup of master database , can someone suggest me a clear, simple and understandable method as I am new to SQL server 2000
April 12, 2007 at 7:40 am
Right click the database in Enterprise Manager, select Backup Database. pick a location and file name.
You can also setup a maintenance plan, select all "system dbs" and configure the backup options (time, location) to meet your needs.
April 12, 2007 at 1:00 pm
Just like any other database. However, you CANNOT do a transaction log backup of the master database. If you use a maintenance plan to do the backups, make sure you do not allow it to do the log backups.
-SQLBill
April 13, 2007 at 3:00 am
Well, I believe differential database is also not allowed for 'Master' database.
April 13, 2007 at 9:22 am
this is the error message that I got back after trying differential backup of master database
Server: Msg 3024, Level 16, State 1, Line 1
You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
So let's say that it's even possible I would still do/recommend full backup since Master database mostly less than 50 MB. That way I restore the fulll backup and I am done.
here is the simple TSQL that backs up your master to your C:\ drive check BOL for more about the backup database syntax.
BACKUP DATABASE Master TO DISK = 'C:\Master.Bak'
Good day,
Bulent
April 13, 2007 at 2:48 pm
thanx for suggesting me the solution, I really appreciate it
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply