restoring from a network drive
I have a database backup that is 180 gb and it is too big to copy to the local machine and restore. I have enough room for the database, but not the database and the backup.
I need to restore this database, but I get this error:
Cannot open backup device “\\milfs2\sqlbackups\MLIBS
However, I have verified the file exists and I can even see it from inside QA when I execute:
exec master..xp_cmdshell 'dir \\milfs2\sqlbackups\MLIBSQ
I get:
Volume in drive \\milfs2\sqlbackups is sqlbackups
Volume Serial Number is 6A01-34AC
NULL
Directory of \\milfs2\sqlbackups\MLIBSQ
NULL
04/17/2005 12:58 AM 186,521,434,624 MLIB_DATAbackup.bak
1 File(s) 186,521,434,624 bytes
0 Dir(s) 850,170,597,376 bytes free
NULL
So I know I can see the file in QA.
What am I doing wrong?
I need to restore this database, but I get this error:
Cannot open backup device “\\milfs2\sqlbackups\MLIBS
However, I have verified the file exists and I can even see it from inside QA when I execute:
exec master..xp_cmdshell 'dir \\milfs2\sqlbackups\MLIBSQ
I get:
Volume in drive \\milfs2\sqlbackups is sqlbackups
Volume Serial Number is 6A01-34AC
NULL
Directory of \\milfs2\sqlbackups\MLIBSQ
NULL
04/17/2005 12:58 AM 186,521,434,624 MLIB_DATAbackup.bak
1 File(s) 186,521,434,624 bytes
0 Dir(s) 850,170,597,376 bytes free
NULL
So I know I can see the file in QA.
What am I doing wrong?
ASKER
Great, making a bit of progress now. However I'm getting a different error
Using the command:
RESTORE DATABASE MLIB_DATA
FROM DISK = '\\milfs2\sqlbackups\MLIBS
I get:
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
So I try to get exclusing access and use:
ALTER DATABASE MLIB_DATA SET SINGLE_USER WITH ROLLBACK IMMEDIATE
and that is successfull.
However when I try:
RESTORE DATABASE MLIB_DATA
FROM DISK = '\\milfs2\sqlbackups\MLIBS
In the same window I get the same error:
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Using the command:
RESTORE DATABASE MLIB_DATA
FROM DISK = '\\milfs2\sqlbackups\MLIBS
I get:
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
So I try to get exclusing access and use:
ALTER DATABASE MLIB_DATA SET SINGLE_USER WITH ROLLBACK IMMEDIATE
and that is successfull.
However when I try:
RESTORE DATABASE MLIB_DATA
FROM DISK = '\\milfs2\sqlbackups\MLIBS
In the same window I get the same error:
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Try changing your database to master and run it from there.
ASKER
Running from the master I get:
Cannot open backup device '\\milfs2\sqlbackups\MLIBS
Cannot open backup device '\\milfs2\sqlbackups\MLIBS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I didn't think you could restore from a network drive. I always thought it had to be a local drive.
sifuhall, were you able to resolve your problem in anyway?
ASKER
No, however the need to restore has been addressed and this is no longer needed.
I would love to know what the problem was, however I do not have the time to continue to troubleshoot this since there is no longer a need to have it restored.
Thanks for the help.
I would love to know what the problem was, however I do not have the time to continue to troubleshoot this since there is no longer a need to have it restored.
Thanks for the help.
RESTORE DATABASE MLIB_DATA
FROM DISK = '\\milfs2\sqlbackups\MLIBS
Please post the command you are trying to execute.