 | |
SQL Backup using SQL Server Management Studio Not Working
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: SQL Backup using SQL Server Management Studio Not Working -
08-04-2008
, 10:10 PM
|
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: 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. |
#12
| |||
| |||
|
|
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: 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. |
#13
| |||
| |||
|
|
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: 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. |
#14
| |||
| |||
|
|
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: 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. |
#15
| |||
| |||
|
|
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: 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. |
#16
| |||
| |||
|
|
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: 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. |
#17
| |||
| |||
|
|
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: 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. |
#18
| |||
| |||
|
|
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: 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. |
#19
| |||
| |||
|
|
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: 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. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.