Hi,
Server: Msg 4212, Level 16, State 1, Line 1
Cannot back up the log of the master database. Use BACKUP DATABASE instead.
The recovery mode is set to full. Why am I not able to back up the log of master
Thanks.
cannot backup log of master
Hot Topic
- Accessing Mobile SQL Databases in VB2005 - Windows Apps
- Detect whether runtime or executiontime in custom component
- SQL Mobile Server Tools install on SQL 2000 SP4
- Variables Not Seen In Custom DataFlow Destination
- Connect to SAS datasets
- Control flow drawing bug
- DTS Assistance required - Very Long!
- Returning top 2 results from each different data in a row and inserting into new table
- this should be easy but it's not.
- Can't uninstall books Online CTP Preview
SQL Server
- Remove the lines from the query output
- mdac upgrade
- SSIS Bulk insert to 2k
- Compatibility Level SQL Server 2000 (80)
- Reporting service with sql server 2005
- Partition help
- Chart Drill Down?
- SQL CMD and Scripting
- create user only with permissions, to select, insert, update, delete, and exec sps
- Backup of 9Gb Database
cannot backup log of master
Joe-B.
Hi,
look here:
http://msdn.microsoft.com/library/default.asp url=/library/en-us/adminsql/ad_bkprst_27qd.asp
"Note Only full database backups of master can be created."
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---