Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deal11deal1
Starting Member
34 Posts |
 Posted - 2008-09-11 : 22:14:39
|
| 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. iIknow 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. Thanxbobby |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
to read TRn file names froma folder and restore it