July 26, 2010 at 12:28 pm
Can anyone plz help me how to take SQL Server 2005 StandbyDB backup steps.
July 26, 2010 at 12:32 pm
What do you mean by standby database?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 26, 2010 at 12:36 pm
Hi, I have a DB in standby mode. There is no trans on DB .All over DB is not in active mode. So is that possiable to take DB full backup.
Thanks,
SAI
July 26, 2010 at 12:38 pm
onemorething we suppose to take Litespeed backup. What steps suppose to follow to take Standby mode DB full backup .
Thanks,
SAI
July 26, 2010 at 12:40 pm
What is standby? There is no status for a database as standby (http://msdn.microsoft.com/en-us/library/ms190442.aspx)
Is this a part of replication? Mirroring? something else?
A database needs to be online in order to take a backup.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 26, 2010 at 12:53 pm
Not using any SQL features. Just DB sitting in Standby mode. Its an DR Server.
Could you please let me know how to take Standby DB full backup through litespeed.
Thanks,
SAI
July 26, 2010 at 12:56 pm
Standby means - in no recovery mode. DB is not in active mode.
July 26, 2010 at 12:56 pm
I think you're confused. There's no such thing as standby mode.
If the server is not being used, it's just not being used. It's not in standby mode. You would take a backup on it the same way that a backup is taken in production.
Please use the Litespeed documentation to read how to take a full backup.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 26, 2010 at 1:12 pm
If the database is restoring, meaning you restored with the NORECOVERY option, you cannot take a backup.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 28, 2010 at 3:03 pm
Yes, you can have a StandBy database. This is very common in Log Shipping, the database is read only and it can help for reporting or queries. This mode is actually a disaster Recovery plan of your primary server, so its already backup/restore there.
you will need to bring the database to recovery mode to be able to backup.
Read this for more information:
July 28, 2010 at 4:27 pm
To remove a DB from StandBy/ReadOnly mode to a Read/Write mode, you can use the following syntax
RESTORE DATABASE <DB Name> WITH RECOVERY
Is this what you need?
July 28, 2010 at 4:40 pm
If you take a database our of restoring status, then you break log shipping.
A backup isn't taken from the secondary database, it comes from the primary.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply