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.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring the Database to a diff architecture
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pareshmotiwala
Constraint Violating Yak Guru

USA
323 Posts

Posted - 08/28/2006 :  13:47:38  Show Profile  Visit pareshmotiwala's Homepage  Click to see pareshmotiwala's MSN Messenger address  Send pareshmotiwala a Yahoo! Message  Reply with Quote
Hi
I 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

USA
191 Posts

Posted - 08/28/2006 :  14:37:17  Show Profile  Visit sanjnep's Homepage  Reply with Quote
I think you should add 6 more log files on your B server as you have added on your A server.

Sanjeev Shrestha
12/17/1971
Go to Top of Page

pareshmotiwala
Constraint Violating Yak Guru

USA
323 Posts

Posted - 08/28/2006 :  17:45:53  Show Profile  Visit pareshmotiwala's Homepage  Click to see pareshmotiwala's MSN Messenger address  Send pareshmotiwala a Yahoo! Message  Reply with Quote
Thank you Sanjnep. The database is in a warm standby mode. so that we can apply more logs.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000