470,855 Members | 1,317 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,855 developers. It's quick & easy.

Setting up backups

I have a database on a shared SQL 2K Server. I need to setup the server
to backup my database, and write the file to a remote NT server (using
a share).

How do I go about this? What permissions would my SQL Server account
require? How can I specify login information for SQL Server to access
the share?

Any good "how to" articles that can walk me through this?



Jul 23 '05 #1
1 1043
1. Make sure the MSSQL service is running under a domain account - see
"Setting up Windows Services Accounts" in Books Online
2. Give that domain account write access to the share where you're
going to put the backups
3. Test the backup:

backup database MyDB to disk = '\\server\share\folder\mydb.bak'

If you're using the Database Maintenance Wizard, see this KB article:



Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Bill Gates | last post: by
reply views Thread by JJ | last post: by
1 post views Thread by Sgt. Sausage | last post: by
1 post views Thread by Loopy | last post: by
3 posts views Thread by db2inst2 | last post: by
21 posts views Thread by Dennis Gearon | last post: by
6 posts views Thread by frank78 | last post: by
1 post views Thread by Polani | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.