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 |
|
arunsqladmin
Yak Posting Veteran
74 Posts |
 Posted - 2008-04-24 : 02:29:44
|
| i am using sql 2005,i want to backup all the databases when i try to schedule a maintenance plan , i dont get all the databases listed event though i authenticate as SA. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-24 : 10:03:38
|
| Why??? |
 |
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-04-24 : 18:06:25
|
| More than likely the 'missing' databases are in a mode that does not allow backups (Offline/Suspect) to be taken. |
|
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2008-04-25 : 01:40:26
|
| but i was able to backup each database manually using the backup database command |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-25 : 22:32:08
|
| Are you looking at full backup or log backup? Log backup page only lists dbs that are not in simple recovery model. |
|
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2008-04-28 : 00:45:30
|
| i am trying to take complete backup (.bak) |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-28 : 01:09:08
|
| So how many databases can you see and how many you can't? what is the status of databases which you can't see? |
|
|
|
|
|
|
unable to backup all the dbs