| Roy Harvey 2002-08-14, 12:23 pm |
| Tim,
>I am having problems restoring a SQL 6.5 Database. I have
>the sql dump files that I created before the server
>crashed. I have recreated the database devices to the
>same size as before. The problem is when I try and create
>a backup device to use to restore I can't get it to let me
>add the file. can someone tell me the steps to go through
>to get a database to restore. thanks in advance
Don't create any backup device for the restore. Use the DISK=
parameter to specify the file location. If the file is located on a
different server, use a UNC as in the example below, rather than
mapped drive.
LOAD DATABASE Bananas
FROM DISK = '\\servername\sharename\direct
ory\banana.dmp'
WITH FILE = 1
Roy
|