Lynn, that duplicate is down to none at all now.

Were you going to say if there was a need to increase the log file to 95 GB and you do...

Other point I wanted to make is if you separate out the components you increase network traffic greatly, so factor that into your decisions.

Greg makes a good point about 64bit.

If you are already 64bit then that is a good argument for running the components together. If you have 64bit and plenty of memory...

correct

if sql is restarted all database have to go through a recovery phase. Your database is currently doing this as a large load was forcibly terminated and there will be...

If you do a full backup it will interfere with their differentials as it will reset the start point for the differentials. Their differentials will still run but there will...

have you tried just bak (no preceding dot). This is what it should be set to.

output the results of sys.dm_db_index_usage_stats to a table so you have persistent, historical information.

have you checked the SQL errorlog for any login failure messages?

A backup transaction command does the same as a backup log. Its not the accepted command though and I expect it will be deprecated at some point (if not already)....

use db statement and other statements need to be in same exec for change of db context to work

e.g.

set @statement = N'use [' + @name +']'+char(13)+N'exec sp_helpdb [' + @name...

passivebyz (6/13/2010)

The key is for your backup drives to be a clustered resource. They should be visible from both nodes, just like the data files. However the physical drives should...

make the backup drive a share then make that share a cluster resource. Then if a node crashes the backup drive will failover as well.

You should also copy the backups...

the people who can analyze dumps are few and far between. I suggest you raise a case with Microsoft. If this is an MS bug you won't be charged.

2008R2 is 2008 + add ons, mostly in the BI area. The core of the release is the same

At the point of releasing 2008R2 MS put up their prices, so...