September 11, 2008 at 7:50 pm
Hello every one.
we are in the process of restoring a database with 1 full backup and about 38 trans log backups. the problem is we have about 180
databases so the process can be very tedious. My manager want's me to come up with either a t-script or batch script so it can just
read the names of the trn files from a folder and plug it in the restore script , he doesnt want me to do it one by one as for 180 databases will take alot of time. I know how to back up and restore but have no idea how to go about make it read it from a file.
i hope every 1 out there will understand by problem . the trn files are sitting in a folder , from there they will be restored.
Thanx
bobby
September 12, 2008 at 1:54 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please, direct replies to:
http://www.sqlservercentral.com/Forums/Topic568224-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply