Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Restore DataBase Question
Message
From
21/09/2004 07:12:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL Server Restore DataBase Question
Miscellaneous
Thread ID:
00944473
Message ID:
00944473
Views:
63
Hello everyone,

I have received a SQL server backup from a customer. The database does not already exist on our SQL server. I am trying to use this backup to establish the database on our SQL server.

I have placed the backup in the standard SQL server backup folder. Using the following command in QA :-
RESTORE DATABASE Computers
	from Computers.bak
I get the following error message(s) :-
Server: Msg 3206, Level 16, State 1, Line 1
No entry in sysdevices for backup device 'Computers.bak'. Update sysdevices and rerun statement.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I tried to restore the backup from EM but there did not appear to be a way to do this because I was unable to specify the source "Computers.bak" file.

Any help would be very much appreciated!

Thank you.

Angie.
Next
Reply
Map
View

Click here to load this message in the networking platform