Having this very same "discussion" with my SAN Admin. Everything has to be RAID 5. The SAN is an EMC NS480. The system has 73 450GB disks 4Gb/s and they...

Hello All -

Does anyone know if the requirements and config of DTC changed with SQL 2008 and Win2008 in a cluster?

I noticed my MSDTC resource (dedicated clustered disk) is...

The version should be 10.00.2766.00

I am encountering a similar problem. I am trying to apply SQL 2008 Cumulative Update 7 for SP1. When I execute SQLServer2008-KB979065-x86.exe

- Click Next to accept license terms

- The next...

We recently performed evals of Litespeed and SQL Backup. We went with SQL Backup for several reasons. One reason is we encountered quirky bugs with the Litespeed GUI in regards...

Did this solutiion work for you? We tried it and we still have a case open with MSFT. We're now trying to get a NetMon trace when the intermittent error...

Great Post!

Any thoughts on the best architecture for creating a standby instance for reporting? Our prod database is over 800GB.

Reporting requirements are during business hours (8:00-5:00).

Log Shipping?

Thank...

If a program requires a login with the SYSADMIN role and rights to Master, will a login with the SYSADMIN role have rights to MASTER by default or does that...

Steve T

************************************************************************************

RESTORE TO EXTERNAL (attached as "K")

***********************************************************************************

restore database xxxxxx from disk = '\\xxxxxxxxx\k$\xxxxxxx_full' with

move 'rrrrrrrr_Data' to 'K:\MSSQL.4\MSSQL\file1.mdf',

move rrrrrrrrrrr_Data' to 'K:\MSSQL.4\MSSQL\file2.ndf',

move 'rrrrrrrrrr_data3' to 'K:\MSSQL.4\MSSQL\file3.ndf',

move rrrrrrrrrrrr_Data' to 'K:\MSSQL.4\MSSQL\file4.ndf',

move 'rrrrrrrrr' to 'K:\MSSQL.4\MSSQL\file5.ndf',

move...

You might be right on. Memory utilization would be something to investigate. We had to make this restore happen. I had a PM hounding me, so I bought a 2...

Hello...Having the same issue with a vendor app, who has suggested entering fake IPs in web page config files. Will push back on that resolution, but I'm a little confused...

I am experiencing a similar issue, although we are using SQL 2005 SP3, Windows 2003.

We are attempting to refresh our Dev database from Prod. The backup is about 700...

The KB references SQL 2008. Is there a KB for 2005?

Thanks

I have a similar problem. I have a database that was restored from Prod to Test. The DB has multiple secondary files. We have purged prod data from this copy...

Rudy,

Nice work! The time you took to document this and share it are what makes this site what it is - A Valuable Resource!

Thank you!

Kevin