March 11, 2005 at 6:47 pm
With Windows 2000, sql server 2000 Enterprise Edition
EM->Tools->Database Maintenance Planner->Next
There are 4 radio buttons.
Problem 1
I was able to proceed with some databases but not with others. Any idea why selecting one db allowed me to check the bottom check box "Ship the transactin logs to other SQL server' and other databases grayed it out?
Following db did not allow log shipping
master, msdb, northwind, and pubs
model db allowed
some of my (user) db allowed to proceed and some of them did not. I did not do anything differnetly while creating my databases.
Problem 2.
As soon as I select anything other than "These databases" bottom check box "Ship Transaction logs to other SQL servers grayed out. I therefore couldn't setup the log shipping.
I want to do "All Databases", Or "All system Databases" and/Or "All user databases"
Problem 3.
While keeping "These databases" radio button selected when I select more than one databases result is the same as of above Problem 1.
My conclusion:
probably log shipping has to be done one database at a time.
But I still do not have the answer for why some database gray out the bottom check box labled "Shit the transaction logs to..."
I will greatly appretiate your help.
munzer
March 13, 2005 at 7:44 pm
Check the recovery model property of the databases. By default, master, northwind, msdb and pubs are set to "simple" which means you can't do a transaction log backup and therefore they can not be involved in log shipping. When the recovery model is set to "simple" the logs are frequently truncated.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
March 13, 2005 at 9:07 pm
Thanks Kathi.
Is it possible to configure log shipping for more than one db in one shot by checking all db or all user db in log shipping dialog box? As soon as I check more than one db log shipping check box grays out. Any idea?
Is there a limit on how many databases one could have in single instance of sql server?
Munzer
March 13, 2005 at 10:46 pm
You can configure log shipping only on one database at a time. If you select more than one database, the log shipping option on the wizard is disabled.
--Kishore
March 13, 2005 at 10:52 pm
Thanks, Kishore.
Is there a miximum limit on number of databses one can create in a single instance of sql server installation?
Munzer
March 14, 2005 at 5:53 am
You can have a maximum of 32,767 databases per Instance of Sql Server 7.0 and SQL Server 2000.
--Kishore
March 14, 2005 at 6:26 am
Thanks a lot again, Kishore and Kathi:
You folks are great in quickly answering questions.
I love this Forum.
Munzer
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply