How to take SQL Server 2005 standby Database backup.

Question

Post reply

How to take SQL Server 2005 standby Database backup.

koya_chandu

Valued Member

Points: 67
More actions
July 26, 2010 at 12:28 pm

#235695

Can anyone plz help me how to take SQL Server 2005 StandbyDB backup steps.

Viewing 12 posts - 1 through 11 (of 11 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

Steve Jones - SSC Editor

SSC Guru

Points: 736212

July 26, 2010 at 12:32 pm

#1198378

What do you mean by standby database?

koya_chandu Valued Member Points: 67 More actions · Answer 2

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

koya_chandu Valued Member Points: 67 More actions · Answer 3

onemorething we suppose to take Litespeed backup. What steps suppose to follow to take Standby mode DB full backup .

Thanks,

SAI

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

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.

koya_chandu Valued Member Points: 67 More actions · Answer 5

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

koya_chandu Valued Member Points: 67 More actions · Answer 6

Standby means - in no recovery mode. DB is not in active mode.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 7

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.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 8

If the database is restoring, meaning you restored with the NORECOVERY option, you cannot take a backup.

MTY-1082557 SSCarpal Tunnel Points: 4540 More actions · Answer 9

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:

http://vyaskn.tripod.com/maintaining_standby_sql_server.htm

Shinoj Ramanathan SSC Eights! Points: 894 More actions · Answer 10

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?

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 11

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.