Re: T-sql to restore log files similar to Log shipping
From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 11/29/04
- Next message: Barry McAuslin: "Re: Bit field returning true or false instead of 1 or 0"
- Previous message: Uri Dimant: "Re: how to make case sensitive query"
- In reply to: Hassan: "Re: T-sql to restore log files similar to Log shipping"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Nov 2004 08:33:10 +0100
Hassan,
I don't have Log Shipping installed to test, but: can't you just script the
Log Shipping jobs with Enterprise Manager?
-- Dejan Sarka, SQL Server MVP Associate Mentor www.SolidQualityLearning.com "Hassan" <fatima_ja@hotmail.com> wrote in message news:u6opy0P1EHA.1392@tk2msftngp13.phx.gbl... > Not really what I planned to do.. I mean I have log shipping in place.. But > say I lost my log shipping restore job which kinda has a plan id to its job > steps, I would love to run one manually. Curious to know how the restore job > thats created by the wizard runs the restores and sequentially accesses the > next file > > > "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in > message news:OyPR2RG1EHA.3368@TK2MSFTNGP10.phx.gbl... > > This is already written, just check the following articles: > > http://www.databasejournal.com/features/mssql/article.php/1467581 > > http://www.sql-server-performance.com/dt_log_shipping.asp > > > > -- > > Dejan Sarka, SQL Server MVP > > Associate Mentor > > www.SolidQualityLearning.com > > > > "Hassan" <fatima_ja@hotmail.com> wrote in message > > news:ueRLqsF1EHA.3616@TK2MSFTNGP11.phx.gbl... > > > Id like to write a TSQL that would restore the log files similar to how > > the > > > automated log shipping restores do. The T-log files have the same format > > as > > > the way the default T-log backups are done with the date appended at the > > > end. Has anyone done this before ? All my T-logs would be saved at a > > > particular Directory and what i dont want is to manually restore all the > > > T-logs one at a time . Id like it to be automated with one script that > > would > > > loop thru every file and restore up until the end.. Or maybe it would be > > > nice to provide parameters such as Path, starting T-log file and ending > > > T-log file > > > > > > Thanks > > > > > > > > > > > >
- Next message: Barry McAuslin: "Re: Bit field returning true or false instead of 1 or 0"
- Previous message: Uri Dimant: "Re: how to make case sensitive query"
- In reply to: Hassan: "Re: T-sql to restore log files similar to Log shipping"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
