By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,011 Members | 2,967 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,011 IT Pros & Developers. It's quick & easy.

Restoration of Transactional log Backup

P: n/a
hi,

I am using SQL SERVER 2000.

My query is, Can I restore my 60 transactional log file backup

in one sql statement,giving condition where it is suppose to start

and end.

example -:
location - : d:\transactionbackup\

a_tlog_200506171546.TRN
a_tlog_200506171548.TRN
a_tlog_200506171550.TRN (start)
a_tlog_200506171552.TRN
a_tlog_200506171554.TRN
a_tlog_200506171556.TRN
a_tlog_200506171558.TRN
a_tlog_200506171600.TRN
a_tlog_200506171602.TRN
a_tlog_200506171604.TRN (end)
a_tlog_200506171606.TRN
a_tlog_200506171608.TRN

I want start my Restoration process of Transactional Logs from 1550 to
1604

Please can any one show a way for this.

Thanks in advance

Richard

Jul 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.