restoring from a network drive
Posted on 2005-04-18
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\MLIBSQL\MLIB_DATAbackup.bak”. Device error or device off-line.
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\MLIBSQL\MLIB_DATAbackup.bak'
Volume in drive \\milfs2\sqlbackups is sqlbackups
Volume Serial Number is 6A01-34AC
Directory of \\milfs2\sqlbackups\MLIBSQL
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
So I know I can see the file in QA.
What am I doing wrong?