I posted this problem last week and still couldn't get this to work.
I have a backed up copy of a production db that i want to test. The production server is using server 7 white i have 2000 at my desktop. How can i get this to work ? I am beginning to 'lose' it.
Any help would be greatly appreciated. I would like to complete this test today.
ThanksWhat is the error message you are getting?|||error message from server7 backup (bak)
Server: Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\TEST'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.|||I met this kind of error before. The reason is the permission at that forlder. So I guess you may check your permission on server box, drive, forlder...|||Man you've been asking that quite a bit...stick to 1 thread...
http://www.dbforums.com/search.php?searchid=111088
Why don't you post the code...
The only one I know who has telepathic powersa is a blind dude...and since he can't see the screen in the first place, that's a good thing...
Now where the hell did he go?
Try this and let us know what you get
RESTORE FILELISTONLY
FROM DISK = '"D:\Tax\BackUp\TaxReconDB.dmp"'
Just change my dump file to yours...my guess is the spaces in the path are your problem...|||Are you asking how to restore a SQL 7 database on SQL 2000?
No comments:
Post a Comment