SQL Server Performance Forum – Threads Archive

RESTORE from local to a remote server

Is the RESTORE command capable to restore a file from my local computer into a remote server? Production’s BAK files are FTPed into my local every night. I want to create a job on my local to RESTORE these files on a remote server.
CanadaDBA

Restoring a Database from a Backup File on a Remote Server to the Local Server
To restore a database from a file that is located on a different computer (for example, restoring from a mapped network drive), the Windows account used to start the SQL Server service has to be a non-system account with full control privileges to the backup file. Restoring a Database from a Local File to a Remote Server
If you are restoring from a local file to a remote server, use a UNC path that points to your local drive from the remote server. The Windows account used to start the remote SQL Server service has to be a non-system account with full control privileges to the backup file.

quote: Is the RESTORE command capable to restore a file from my local computer into a remote server? Production’s BAK files are FTPed into my local every night. I want to create a job on my local to RESTORE these files on a remote server.

The Windows account used to start the remote SQL Server service has to be a non-system account with full control privileges to the backup file.
Assume that SQLAdmin is the Windows account in the remote server, which starts the SQL Server service. Do you mean I need to grant full access rights to my local to the SQLAdmin? How?
CanadaDBA

you need to grant acees privilege rigths to remote user for the required folders.

Yes, you can restore it but you only need the UNC path……
Thanks Noor
MCDBA

To implement my need, (1) I can FTP the BAK files from production to my local and then to the other server then restore the BAK on the server. Or (2) I can set a job on the second server and restore directly from backups in the production. Our production is not busy at night. Which one do you recommend?

quote:Originally posted by naissani Yes, you can restore it but you only need the UNC path……
Thanks Noor
MCDBA

CanadaDBA

I will suggest with option (1) and ensure no issues with network. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>