Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restoring a sql backup from another server Expand / Collapse
Author
Message
Posted Tuesday, September 9, 2008 12:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 15, 2008 4:31 PM
Points: 3, Visits: 6
Hello:

We have two sql servers one is HR uat and HR production.
We want to refresh the HR uat server with production data.
Are standard way has been to move the .bak file from the HR production server into the HR UAT server and load it. However we are running out of
space on the HR uat server and we wanted to know if we can load the .bak file from another server instead of copying the .bak to the HR uat server. Our SQL Admin is not sure we can do this. Any ideas are welcome.

Thanks.


Post #566410
Posted Tuesday, September 9, 2008 12:52 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
You might be able to do it from a UNC path to a shared directory on the network, but it often bombs out.

Can you clear out some space on the uat server? (I know, really obvious question that I'm sure you've already thought of, but I have to ask.)


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #566413
Posted Tuesday, September 9, 2008 12:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 15, 2008 4:31 PM
Points: 3, Visits: 6
We cleared all the files and temp folders that we could find but we are still short on disk space.

Post #566419
Posted Tuesday, September 9, 2008 1:40 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:19 AM
Points: 2,826, Visits: 8,462
I've never had a problem backing up or restoring via UNC path in SQL. I don't do it a lot, it's not ideal, and it's slow, but it does work in a pinch.


Post #566447
Posted Tuesday, September 9, 2008 3:10 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, January 2, 2014 1:54 PM
Points: 396, Visits: 246
To answer the question, I have occasionally had the need to restore from backup via a UNC path across the LAN, and I haven't seen any issues. I have had a similar attempt die across a WAN link.

All that said: the .mdf is going to be larger than its .bak; if you don't have space on the server for the .bak, are you sure you've got enough space for the .mdf?


______
Twitter: @Control_Group
Post #566498
Posted Tuesday, September 9, 2008 3:44 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 27, 2014 11:17 PM
Points: 309, Visits: 814
Hi,
1) Share the folder in the HR Prod Server where .bak files are present.
2) In the security of the sharing give read permission to the SQL Server Service account running in HR UAT Server.
3) Open Internet Explorer in HR UAT Server using Run as option and type the HR UAT SQL Service Account and in the address bar type the HR prod backup shared path for ex: \\HRSer\d$\Backups\ and check you are able to access the path without security errors.
4) Now run your usual Restore command but path will be the share path (UNC Path) For Ex:
RESTORE DATABASE tunein FROM DISK=N'\\\\HRSer\d$\Backups\tunein.bak' WITH
STATS=5

Note:
Incase there is a network error/latency then restoration may get affected. Ensure that network speed between both servers are good!


Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Post #566514
Posted Wednesday, April 30, 2014 4:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 2:11 AM
Points: 5, Visits: 11
Yes you can retrieve a BAK file from a remote server to a local harddidsk using this tool and then restore your DB from the local BAK file.
Post #1566302
Posted Wednesday, April 30, 2014 5:30 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 1,306, Visits: 2,470
SQLFan888 (4/30/2014)
Yes you can retrieve a BAK file from a remote server to a local harddidsk using this tool and then restore your DB from the local BAK file.


Please note, the thread you are replying to is more than 5 years old.



Sujeet Singh
Post #1566324
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse