-
Want to backup to different server
G'day people
I'm new to the world of databases and I hope you can help me.
I am running MSSQL2000 and I want to set-up a regular backof the the database. However, I want to back it up to a folder on another server. I can't figure out how to select the other server. It only gives me the option of saving on either the C: or D: drives on the server that MSSQL sits on.
Am I missing something?
Hope you can help.
Cheers
Al
-
1. Make sure your SQL Server service runs under a domain account say mydomain\myuser
2. Make sure you share the folder on the other driver say MyShare
3. Your backup command should be
backup database mydatabasename to disk='\\remoteserver\myshare\mydatabasename.bak'
-
2a. Make sure Mydomain\Myuser has permission to Myshare shared folder name on the remote server
-
Thanks for that. I've checked the SQL server service and it is running under a domain account, the administrator domain account.
I just tried backing up through a TSQL script and it works fine! However, can't do it via the SQL Server Enterprise Manager. Very strange...
-
Should be able to, just specify file location with unc name.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|