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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2013-03-04 : 10:51:23
|
| Hi Experts,Need a small help as I got a situation where I need to restore (with over write) a database, here the situation is on the source database there are 2 log files but when I see on the destination database it is only one. I feel that we can’t restore on this, please suggest me if I am wrong.Thanks in Advance.Thank You All In AdvanceKRS39 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-03-04 : 11:06:52
|
| That should work fine. If you're using t-sql to do the restore then you just need to specify WITH REPLACE in the commandBe One with the OptimizerTG |
 |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2013-03-04 : 11:38:30
|
| Hi TG,Sorry i didn't get you. can you be bit more specific.Thank you in Advance.Thank You All In AdvanceKRS39 |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-03-04 : 13:38:02
|
| You CAN restore a database that already exists at the target. And it makes no difference if the source has two log files but the existing target only has one.Let us know if you have any problem performing the restore.Be One with the OptimizerTG |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
Database restore