Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Restore DataBase Question
Message
From
21/09/2004 07:25:30
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00944473
Message ID:
00944476
Views:
10
This message has been marked as the solution to the initial question of the thread.
>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.

Angie,
I think you can do it with EM selecting Database\All tasks\Restore. AFAIK there select device lets you point a file and change restore as ...
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform