SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup of Standby DB (Transaction logs)


Backup of Standby DB (Transaction logs)

Author
Message
saad_Ahmad1
saad_Ahmad1
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 8
I have restored a DB backup image sent to us from our client in Standby mode.
After I have restored the DB backup image in Standby mode, I restore daily transaction logs that are shipped to me.

Every month I would like to a backup of this Database so that if something fails, I only have to restore the backup taken at the end of the month rather then catching up on 4-5 months of T-logs.

What I tried to do is as follows:

-Restore the DB backup image (sent by client) in Standby Mode for Jan 1/09.

-Apply T-logs (sent by client) to this Standby Database up until Jan 30/09

-For the Jan 31 T-log, I applied this against the DB but the option I selected to apply this T-log was in Restore Recovery mode

-Purpose was to be able to take a backup image.

-After I took the backup image, I restored the backup image into Standby Mode so that it can accept the Feb 1/09 T-log

-When I tried to apply the T-log I got the error

'This backup set cannot be applied because it is on a recovery path that is inconsistent with the database'

Why is that? Anyone have a workaround?
ps.
ps.
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7491 Visits: 3668
see if this can be of some help!!
http://www.mssqltips.com/tip.asp?tip=1464



Pradeep Singh
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)

Group: General Forum Members
Points: 99948 Visits: 39000
By doing that, you have broken the log chain from the source database (client). About the only way I can see around this would be do shut SQL Server down and then make a copy of the mdf/ldf files. Not sure if this will work, but it is worth a try.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
saad_Ahmad1
saad_Ahmad1
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 8
If I make a copy of the .mdf and .ldf of the StandBy Database and then drop the Standby Databse, how do I restore it?
saad_Ahmad1
saad_Ahmad1
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 8
Tried it but no luck..any other ideas?
tosscrosby
  tosscrosby
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5888 Visits: 5316
If you have the .mdf and .ldf you can simply attach the database, no restore involved. If it's truly a .bak, then it's restore database.

-- You can't be late until you show up.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search