September 7, 2010 at 11:37 am
If you get the transport error, either you're restoring across a network, or the file is corrupted.
Please post the code you are using to do this restore, and list the exact error from your latest test
You can backup to multiple files when you run the BACKUP command (or have multiple files listed in the SSMS gui)
BACKUP DATABASE AdventureWorks2008R2
TO DISK='X:\SQLServerBackups\AdventureWorks2008R2_1a.bak',
DISK='Y:\SQLServerBackups\AdventureWorks2008R2_2a.bak',
DISK='Z:\SQLServerBackups\AdventureWorks2008R2_3a.bak'
BACKUP - http://technet.microsoft.com/en-us/library/ms186865.aspx
September 8, 2010 at 5:46 am
Sushant,
I've seen the network error as well.
We are using a SAN, and that was causing problems.
Upgrading SAN drivers helped, and we now restore 1 TB databases onto a report server each night.
Best regards,
Henrik
September 8, 2010 at 6:28 am
Did you try your restore using the "restart" parameter ?
I've had a similar issue with a bak file >99Gb.
If I'm correct, it was related to some W2003 32bit bug on our systems.
Only by restarting the backup (same statement + ', restart' should do) a couple of times got it to succeed in that case.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2010 at 7:16 am
I RAN:--
RESTORE DATABASE XYZ
FROM DISK = 'E:\xyz_backup_201009022015.bak'
WITH MOVE 'logical_name.mdf' TO 'E:\SQLDatabases\XYZ.mdf',
MOVE 'logical_name.ldf' TO 'E:\SQLLogs\XYZ.ldf',
STATS=5
I recevied error:-
Msg 64, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
September 8, 2010 at 8:03 am
SKYBVI (9/8/2010)
I RAN:--RESTORE DATABASE XYZ
FROM DISK = 'E:\xyz_backup_201009022015.bak'
WITH MOVE 'logical_name.mdf' TO 'E:\SQLDatabases\XYZ.mdf',
MOVE 'logical_name.ldf' TO 'E:\SQLLogs\XYZ.ldf',
STATS=5
I recevied error:-
Msg 64, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Regards,
Sushant
Check your session (disconnected ?).
WITH MOVE 'logical_name.mdf' TO 'E:\SQLDatabases\XYZ.mdf',
MOVE 'logical_name.ldf' TO 'E:\SQLLogs\XYZ.ldf',
I have the impression you might mix things up.
Just to check:
Can you post the result of this statement ?
-- show backup file content regarding db files
restore filelistonly from DISK = 'E:\xyz_backup_201009022015.bak'
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 9, 2010 at 10:47 am
@ above all
Restoring completed successfully.
I ran the restore script from SSMS inside the RDP.
earlier i was doing from outside.
Thanks all for your valuable suggestions
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
September 9, 2010 at 10:51 am
Great to hear, and glad it worked.
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply