If you can drop and re-create the logins on server B then you don't need to synchronize the databases one by one. This is a KB article explaining the login...

You need to have a file share on the primary server (or somewhere on an intermediary server) which should be accessible from the secondary server. This will likely require some...

See this KB article for details on required security settings:

http://support.microsoft.com/kb/321247

Hi Danky,

I think in your case the problem is that you're deleting all records in a single delete statement. SQL treats is as a single transaction and it's logged all...

First of all, it's important to approach this question from business perspective rather than dev/admin perspective.

What are your expectations for business growth? A new customer per day or a new...

Then check this: http://support.microsoft.com/kb/317375 and this:

http://support.microsoft.com/kb/198514/

Basically you have to publish the database somewhere on a server which has Publishing enabled and then unpublish it if you...

Can you run DBCC LOGINFO and DBCC OPENTRAN and post the output?

Has the database been published before? Or restored from a backup of a published database?

Hi Jason,

Based on the info you have I'd suggest to make a RAID 1 of the two new drives and put all the transaction logs including tempdb's log there.

However, more...

David,

yes, you have to have a set of backups of master/msdb/model DBs. In addition I'd suggest to learn, document and practice the restore process for system databases. There are Microsoft...

If you don't care about data/logins/etc. you can just rebuild the system DBs using "Rebuild Master" Rebuildm.exe utility

We run a similar configuration here and Micorosft PSS has recommended to set max. server memory to 6GB.

Could it be because of the execution plan re-use? I.e., you execute the query first for mid-november and the plan is cached. Then when you run it for the recent...

This is really cool!

I'm thinking of using these techniques and combining them with standard SSMS reports and/or performance dashboard reports. That would be a nice muli-server monitoring solution.

Thanks Rodney!

You might have to add the new disk to the SQL server dependencies using Cluster Admin. Check this KB article:

http://support.microsoft.com/kb/835185

Hi Vika,

First of all, try to find out why the database grew up to 28GB with only 0.5GB used. Is it used as some sort of staging storage for periodic...