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 |
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2006-08-28 : 13:47:38
|
HiI have a database (say A)which has 7 data files, and one log file.We apply transaction logs from this one to a database in warm standby (say B). This Friday we changed the design of the database from 7+1 to 7+7(i.e. 7 data files and 7 log files). Unfortunately when I tried to apply the logs from this newly designed database could not be applied to Database B which was still on old design.Is there any ways to restore just the logs and not having to restore the entire database.? |
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2006-08-28 : 14:37:17
|
I think you should add 6 more log files on your B server as you have added on your A server.Sanjeev Shrestha12/17/1971 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2006-08-28 : 17:45:53
|
Thank you Sanjnep. The database is in a warm standby mode. so that we can apply more logs. |
|
|
|
|
|