I prefer using DTS. It is pretty easy to use and has been proven to be faster that bulk copy for large amount of data. you can use DTS to copy from...

select database_name,physical_device_name,backup_start_date,backup_finish_date from msdb..backupmediafamily a join msdb..backupset b on a.media_set_id = b.media_set_id  where backup_start_date > '2004-10-06'

Just to add ont o what yelena mentioned. You can split your tables as much as you want and then create a view on top of all your small tables if...

I don't think you can specify a "\" in the DNS. But check with your admins and hope they might be able to give you a better handle. If not,...

ODBC drivers are part of MDAC. Uninstalling SQL should not impact the MDAC libraries and I think something might have gone wrong during the un-install resulting in corrupting your MDAC libraries.  You...

Grant sa  access to the cluster account and then revoke builtin\admin role.  Below is the KB article.

http://support.microsoft.com/?id=263712

A non zero kpid means that the spid is in runnable state. Try to recylce the service or program which created this spid.

The value for alias is stored in registry under HKEY_LOCAL_MACHINE -> Software -> Microsoft -> MSSQLSERVER -> ConnectTo. In case of disaster recovery, if you are restoring the registry, it...

Can you check if there are any open transaction creating issues. Try running DBCC opentran.

I'm not sure if i understood your question correctly but if you are trying to make active/active out of two existing servers having sql installed, you can follow the steps below

1) You...

Try querying restorehistory table on your secondary server and this should give you an idea about the last log file restored.

Run the SQL installation program and give the virtual name as the server and this will walk you through the un-installation wizard.

Regarding high queue lengths, from what i have seen in our shop is that this value is generally a good place to look at when you would like to tune your...

I once ran into this error and resticting max degree of parallelism resolved our issue. One of the behaviors which i saw was that sysprocesses would show huge no. of...

Was this high disk queue length witnessed during regular health check or you ran into some performance issues and withnessed this.