Networks

Ask something
Question Locked

Nightly automated backup of SQL server

0 helpful
3 replies

by abdullah.adam

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want a nightly dump of my sql server 2005 database, how can I do this without having some special permissions? Is there a script I can schedule to run? Pls note I am on a shared hosting environment with a shared sql server.

3 replies

by bart777

Configure the maintenance plan inside of SQL for the DB. Tell it to backup to which ever location you have access to.
Schedule the backup to run each night and you can also tell it hom may copies to save.

by Member 30634329

What permissions does your SQL account have?
You can only backup a SQL database (by default) if you are a member of the sysadmin role on the server, or are in the db_owner or db_backupoperator roles in the database.

This discussion is closed to new replies.