Results 1 to 5 of 5

Thread: Cold backup

  1. #1
    Join Date
    Aug 2003
    Posts
    62

    Unanswered: Cold backup

    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 ?

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    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.

  3. #3
    Join Date
    Aug 2003
    Posts
    62
    Thank U for your help

  4. #4
    Join Date
    Jun 2003
    Posts
    31
    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.

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •