September 9, 2008 at 12:49 pm
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.
September 9, 2008 at 12:52 pm
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
September 9, 2008 at 12:58 pm
We cleared all the files and temp folders that we could find but we are still short on disk space.
September 9, 2008 at 1:40 pm
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.
September 9, 2008 at 3:10 pm
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
September 9, 2008 at 3:44 pm
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
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply