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 |
|
drewdown
Starting Member
4 Posts |
 Posted - 2009-03-10 : 12:30:58
|
| I have used these before, however I am having a problem where 1 SQL database is giving me fits. When I attempt to setup a maintenance plan for a specific database SQL does not give me the option to select that database. IE if I go to 'Back Up Database Task' and under 'Databases' go to 'These Databases:' the database in question is not on the list, thus making it impossible for me to select it. The only way I can back it up now is manually, which I don't want to do.Does anyone know why I am not able to select it? I am on the physical SQL Server and that database resides there. I have other maintenance plans running without fail. I have dbo access but for the life of me don't understand why it doesn't show/allow me to select it.Thanks |
|
|
mfemenel
Professor Frink
1421 Posts |
|
|
drewdown
Starting Member
4 Posts |
Posted - 2009-03-10 : 13:27:47
|
| HideInstance is set to 'No.' Any other idea's? I can see all the other databases, the two pertaining to a specific application I cannot see. |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-03-10 : 13:31:55
|
| What is your permission level to those 2 databases?Mike"oh, that monkey is going to pay" |
|
|
|
drewdown
Starting Member
4 Posts |
Posted - 2009-03-10 : 14:12:31
|
| dbo for my windows account and local SQL account. Neither of which allow me to 'see' that database when I try to create a main. plan. I can manually back it up, change permissions, etc.. |
|
|
|
drewdown
Starting Member
4 Posts |
Posted - 2009-03-12 : 12:30:24
|
| Bueller? Anyone know why I am not able to select a database via the maintenance plan wizard? |
|
|
|
|
|
|
Help with Maintenance Plan