Post reply

Backing SQL DB

  • September 11, 2008 at 8:10 am

    #212559

    How do I stop a SQL database from being in warm stand by mode?

  • September 11, 2008 at 8:45 am

    #870372

    RESTORE DATABASE database name WITH RECOVERY

    Greg

  • September 11, 2008 at 8:49 am

    #870377

    Hi I tried the command and it says that the Database is in use.

    Thanks.

  • September 11, 2008 at 8:54 am

    #870381

    Is there a restore operation occurring? It could be in STANDBY, which would allow read connections to it. You would need to remove those connections. Either tell people to disconnect or use KILL.

  • September 11, 2008 at 9:04 am

    #870391

    Hi,

    I am not aware of a restore operation that being performed on the DB. I was having issues with by Disk to disk backup, which turn out to be vend hardware issues, so I had the backup software tech support helping me out with the setup of the backup job. However the disk backup is not taken out of commission and now every time I am doing a full backup to tape I get the message that the DB is in standby state. I am not a DBA so I do have issues with running SQL command.

    So I am still stuck with not able to do a full backup because for some reason the DB is still is warm standby state. I try the command RESTORE DATABASE as mentioned one of the DB and it works but when I tried it on others I got the message that the DB is in use.

    any suggestions is very much appreciated.

    Thanks.

  • September 11, 2008 at 9:40 am

    #870425

    I would like to thank everyone who replied to by post. I got everything working by using some of your suggestions.

    Thanks again.

Viewing 6 posts - 1 through 6 (of 6 total)

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