Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-27 : 08:37:36
|
| John writes "I am trying to run a database backup job on a SQL Server 7 (7.00.1063) on Windows NT (4.00.1381). The job never ends, I can issue a STOP JOB command which eventually cancels the job. After I cancel the job there isn't an entry in the SQL Server log that even shows a backup was attempted. I can do a database backup by right clicking on the database and selecting ALL TASKS/Database Backup. Backup jobs for other databases on this server are working. There is plenty of disk where the backup should go, the database is only about 10 meg. This backup had been working for over six months before it started to hang. I deleted the maintenance plan and rebuilt the plan but the job still hangs. Can you give me additional things I should check. Thanks." |
|
|
davy_boy2000
Starting Member
28 Posts |
Posted - 2002-09-30 : 05:36:17
|
| Can the backup task be ran as an isql/osql command string?If so, then you could schedule this as a command exec task. That should get you around the 'unable to schedule' problem. |
 |
|
|
|
|
|
maintenance job database backup hangs