Any time we try to create a backup of a database using any method, including
the backup option on the All Tasks menu, the backup never starts but just
sits there with the word executing.

We have made backups and I am not sure what would have changed to prevent
backups from working.

Any help you can provide would be appreciated.
--
Charles Allen, MVP

What is the recovery model? How big is the database? What happens when you
run

BACKUP DATABASE foo TO DISK = 'C:\foo.bak';

in a query window? Did you check the file system to see if the BAK file got
created, and if it is being written to? Did you check the SQL Server error
logs, or the event logs on the server? Are you sure the account has write
privileges to the backup folder location specified in the GUI? Are you sure
you used the GUI for this before? Are you sure you used exactly the same
options and that nothing about the database has changed?




On 8/4/08 10:53 PM, in article
80C34E50-8EBB-4A16-9340-46E5B52AC819...soft (DOT) com, "Charles Allen"
<callen (AT) nospam-bkd (DOT) com> wrote:

What is the recovery model? How big is the database? What happens when you
run

BACKUP DATABASE foo TO DISK = 'C:\foo.bak';

in a query window? Did you check the file system to see if the BAK file got
created, and if it is being written to? Did you check the SQL Server error
logs, or the event logs on the server? Are you sure the account has write
privileges to the backup folder location specified in the GUI? Are you sure
you used the GUI for this before? Are you sure you used exactly the same
options and that nothing about the database has changed?




On 8/4/08 10:53 PM, in article
80C34E50-8EBB-4A16-9340-46E5B52AC819...soft (DOT) com, "Charles Allen"
<callen (AT) nospam-bkd (DOT) com> wrote:

What is the recovery model? How big is the database? What happens when you
run

BACKUP DATABASE foo TO DISK = 'C:\foo.bak';

in a query window? Did you check the file system to see if the BAK file got
created, and if it is being written to? Did you check the SQL Server error
logs, or the event logs on the server? Are you sure the account has write
privileges to the backup folder location specified in the GUI? Are you sure
you used the GUI for this before? Are you sure you used exactly the same
options and that nothing about the database has changed?




On 8/4/08 10:53 PM, in article
80C34E50-8EBB-4A16-9340-46E5B52AC819...soft (DOT) com, "Charles Allen"
<callen (AT) nospam-bkd (DOT) com> wrote:

What is the recovery model? How big is the database? What happens when you
run

BACKUP DATABASE foo TO DISK = 'C:\foo.bak';

in a query window? Did you check the file system to see if the BAK file got
created, and if it is being written to? Did you check the SQL Server error
logs, or the event logs on the server? Are you sure the account has write
privileges to the backup folder location specified in the GUI? Are you sure
you used the GUI for this before? Are you sure you used exactly the same
options and that nothing about the database has changed?




On 8/4/08 10:53 PM, in article
80C34E50-8EBB-4A16-9340-46E5B52AC819...soft (DOT) com, "Charles Allen"
<callen (AT) nospam-bkd (DOT) com> wrote:

What is the recovery model? How big is the database? What happens when you
run

BACKUP DATABASE foo TO DISK = 'C:\foo.bak';

in a query window? Did you check the file system to see if the BAK file got
created, and if it is being written to? Did you check the SQL Server error
logs, or the event logs on the server? Are you sure the account has write
privileges to the backup folder location specified in the GUI? Are you sure
you used the GUI for this before? Are you sure you used exactly the same
options and that nothing about the database has changed?




On 8/4/08 10:53 PM, in article
80C34E50-8EBB-4A16-9340-46E5B52AC819...soft (DOT) com, "Charles Allen"
<callen (AT) nospam-bkd (DOT) com> wrote:

What is the recovery model? How big is the database? What happens when you
run

BACKUP DATABASE foo TO DISK = 'C:\foo.bak';

in a query window? Did you check the file system to see if the BAK file got
created, and if it is being written to? Did you check the SQL Server error
logs, or the event logs on the server? Are you sure the account has write
privileges to the backup folder location specified in the GUI? Are you sure
you used the GUI for this before? Are you sure you used exactly the same
options and that nothing about the database has changed?




On 8/4/08 10:53 PM, in article
80C34E50-8EBB-4A16-9340-46E5B52AC819...soft (DOT) com, "Charles Allen"
<callen (AT) nospam-bkd (DOT) com> wrote:

What is the recovery model? How big is the database? What happens when you
run

BACKUP DATABASE foo TO DISK = 'C:\foo.bak';

in a query window? Did you check the file system to see if the BAK file got
created, and if it is being written to? Did you check the SQL Server error
logs, or the event logs on the server? Are you sure the account has write
privileges to the backup folder location specified in the GUI? Are you sure
you used the GUI for this before? Are you sure you used exactly the same
options and that nothing about the database has changed?




On 8/4/08 10:53 PM, in article
80C34E50-8EBB-4A16-9340-46E5B52AC819...soft (DOT) com, "Charles Allen"
<callen (AT) nospam-bkd (DOT) com> wrote:

What is the recovery model? How big is the database? What happens when you
run

BACKUP DATABASE foo TO DISK = 'C:\foo.bak';

in a query window? Did you check the file system to see if the BAK file got
created, and if it is being written to? Did you check the SQL Server error
logs, or the event logs on the server? Are you sure the account has write
privileges to the backup folder location specified in the GUI? Are you sure
you used the GUI for this before? Are you sure you used exactly the same
options and that nothing about the database has changed?




On 8/4/08 10:53 PM, in article
80C34E50-8EBB-4A16-9340-46E5B52AC819...soft (DOT) com, "Charles Allen"
<callen (AT) nospam-bkd (DOT) com> wrote:

What is the recovery model? How big is the database? What happens when you
run

BACKUP DATABASE foo TO DISK = 'C:\foo.bak';

in a query window? Did you check the file system to see if the BAK file got
created, and if it is being written to? Did you check the SQL Server error
logs, or the event logs on the server? Are you sure the account has write
privileges to the backup folder location specified in the GUI? Are you sure
you used the GUI for this before? Are you sure you used exactly the same
options and that nothing about the database has changed?




On 8/4/08 10:53 PM, in article
80C34E50-8EBB-4A16-9340-46E5B52AC819...soft (DOT) com, "Charles Allen"
<callen (AT) nospam-bkd (DOT) com> wrote: