|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > Maintenance Plan Backup Failing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Maintenance Plan Backup Failing
|
|
| KParchinski 2002-10-05, 9:13 pm |
| I created a maintenance plan to back up the database and transaction log;
however, because processes or users leave themselves logged on the backup
fails. Can I write a stored procedure to loop through the server or
database processes to view and then kill the guilty processes? If so, can I
insert this stored procedure as a step in the Maintenance Plan job? If the
stored procedure can be written, which table(s) can I find server an
database process information? Thanks in advance.
Regards,
Ken
| |
| mountain man 2002-10-05, 9:13 pm |
| "KParchinski" <kparchin@frontiernet.net> wrote in message
news:uot5femf0ujfbb@corp.supernews.com...
> I created a maintenance plan to back up the database and transaction log;
> however, because processes or users leave themselves logged on the backup
> fails. Can I write a stored procedure to loop through the server or
> database processes to view and then kill the guilty processes? If so, can
I
> insert this stored procedure as a step in the Maintenance Plan job? If
the
> stored procedure can be written, which table(s) can I find server an
> database process information? Thanks in advance.
1) Recreate the backup using the backup option.
2) Database backups do not require exclusive use.
3) Certain maintenance plans do: worry about them later.
--
Farmer Brown
Falls Creek, OZ
http://www.mountainman.com.au/software
|
|
|
|
|