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 |
awojtowicz
Starting Member
3 Posts |
Posted - 2005-01-13 : 11:12:41
|
I have a maintenance plan in sql 2000 that gives me errors about not being in single mode. it won't back up any database. i'm not a sql guy but i have to maintain a couple of databases.thanks |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-13 : 12:32:06
|
Is that single user mode?Did you request it to do an integrity check and repair databases?If so then that's the problem.Don't use maintenance plans - it's easy to code it yourself and then you know what it is doing.Here's an sp that will bcak up all databaseshttp://www.mindsdoor.net/SQLAdmin/BackupAllDatabases.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
awojtowicz
Starting Member
3 Posts |
Posted - 2005-01-13 : 13:23:15
|
Yes single user mode. so i guess i should uncheck the integrity check, huh? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-13 : 13:50:23
|
yep.You can run dbcc checkdb if you want to.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|