Hello,
I'm new in SQL Server database administration, and I'm looking for creating a cold backup, bases stopped.
What is the way the do it ?look at Backup Database in bol (books on-line).
You can also do it by right clicking on the database and selecting all tasks, backup database in enterprise manager.
It doesn't matter whether or not your system is active when you take a backup.
Also make sure the recovery mode is set to simple or you take transaction log backups or the log will grow to fill the disk and then the server will crash.|||Thank U for your help|||What nigelrivett suggested actually is a "HOT" backup (meaning the database is still ACTIVE while you're doing the backup). COLD backup means the databases are down, no connection or activity occurred in order to create a consistency database backup. You should use either one of 2 methods below:
Method #1
1) Put the database in single user mode & DBO only
2) Do the full backup
Method #2
1) use SP_DETACH_DB (see BOL) to disconnect/stop the database.
2) Copy the database's files to another server
3) use SP_ATTACH_DB to re-attach and open the database for user.
Good Luck.|||Method #3
use master
go
exec sp_dboption [database_name], 'off', true
go
--see method #2 step 2
exec sp_dboption [database_name], 'off', false
go
No comments:
Post a Comment