Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Backup failed across a network on a shared drive...
- Thread starter SteveMe
- Start date
You cannot do backup to a mapped network drive, you have explicitally give the share location. Refer the below example.
\\ServerName\ShareFolderName\
RESTORE DATABASE MyDb
FROM Disk = '\\serverA\Mssql\Backup\Mydb.bak'
WITH STANDBY = 'C:\MSSQL\Log\undoMyDb.ldf', MOVE 'MyDb_Data' TO 'C:\MSSQL\Data\MyDb_data.mdf',
MOVE 'MyDb_log' TO 'C:\MSSQL\Log\MyDb_log.ldf'
GO
Try this
Dr.Sql
Good Luck.
\\ServerName\ShareFolderName\
RESTORE DATABASE MyDb
FROM Disk = '\\serverA\Mssql\Backup\Mydb.bak'
WITH STANDBY = 'C:\MSSQL\Log\undoMyDb.ldf', MOVE 'MyDb_Data' TO 'C:\MSSQL\Data\MyDb_data.mdf',
MOVE 'MyDb_log' TO 'C:\MSSQL\Log\MyDb_log.ldf'
GO
Try this
Dr.Sql
Good Luck.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question