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 |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-10-13 : 05:24:53
|
| Hi Guys can someone please assist me.I have a SQL 2005 Job called BackupAndRestoreThat basically backups a DB and restores it over another DB.Step 1BACKUP DATABASE DBParent TO DBParentDataDEVGOStep 2BACKUP LOG DBParentTO DBParentLogDEVStep 3RESTORE DATABASE DBChildFROM DBParentDataDEVWITH REPLACEPlease note that i'm restoring the backup of the Parent DB over the Child DB.This fails on step 3 with no error information.Both the Data and the log file are present after step 1 and 2.What am i doing wrong here. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-13 : 06:11:41
|
quote:
This fails on step 3 with no error information.
Did you check the SQL Errorlog?Are you running these commands in SSMS, or command line/batch? |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-10-13 : 06:11:51
|
| You probably need WITH MOVE for the physical file locations. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
transact sql backup and restore