Click to See Complete Forum and Search --> : Backup Database


WesTurrant
May 1st, 2007, 09:27 PM
I am trying to backup my data in SQL 2005 SSMS and it gives me an error saying access denied.

Why am I denied access to my own database?

TheCPUWizard
May 1st, 2007, 09:30 PM
1) Are you a db_owner, or at least have the appropriate privs to the db?
2) Do you have write priv to the target location?
3) Atr other users currently accessing the database?