Post reply

Backup a currently running database

  • December 3, 2003 at 10:20 am

    #107014

    Is it possible to backup a currently runnig database (Solarwinds) using Enterprise Manager? 2nd will it kick users connected to it?

    Any Help would be greatly appreciated.

  • December 3, 2003 at 11:01 am

    #484487

    If you mean "Hot Backups" then, with SQL server it is possible to backups running databases, without stoping the server.

    Users won't notice that you are backing up the Db, except for the performance depending on your hardware, etc...

  • December 5, 2003 at 8:21 am

    #484839

    racosta,

    Thanks I appreciate it.

  • December 5, 2003 at 9:44 am

    #484862

    It depends on how you do your backups. The 'native' SQL Server backups (using the BACKUP tsql command) work while the database is being used.

    Using third-party backup tools, can require you to put the database in SINGLE user mode and kick users out.

    This is why I use the BACKUP commands to backup to disk and then use my backup software to COPY the backup file to tape.

    -SQLBill

  • December 5, 2003 at 10:32 am

    #484876

    quote:

    Using third-party backup tools, can require you to put the database in SINGLE user mode and kick users out.

    I believe you must mean OFFLINE (or detaching the database or stopping the server), which will allow backing up the files. The files are still in use by SQL Server in SINGLE_USER mode.

    --Jonathan



    --Jonathan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply