Hmm, sorry for late reply.

I didn't realize article got republished. My apologies, ever since I started working at Microsoft I have not had opportunity to follow SQL Server Central...

Gail's approach would be the recommend way, instead of you trying to reverse engineer it. SQL Express doesn't cost anything and you can quickly find out, instead of...

In the database mirroring endpoints do not specify the instance name. Should be http://servername.fqdn:port.

Make sure to run it through SQL Server 2012 upgrade advisor to make sure there are no hidden surprises. Also you might want to do depreciated feature analysis in...

Nope. AlwaysOn Availability Groups is a SQL Server 2012 functionality. The windows failover cluster can be Windows 2008 R2 sp1, however SQL versions cannot be mixed.

Cheers!

Ha Good idea, makes it hard to reply to it. Luckily I still had alerts on this one heh :P.

Yeeh for SSC Alerts :D.

Hi,

I am sorry I can't tell you how to check that setting on your SCSI controller; I had my SAN guy do it. That time...

You are limited with it comes to SQL Server 2000 and 2005 without SCOM. You can look at implementing SQL Server Server side trace to capture the security events,...

Looks like you have a server side trace script there created from SQL Server Profiler. As Ninja said, every time we start SQL Server Profiler to collect trace it...

JTS: RID Lookup is used to retrieve information from the table that is not part of the index. For example lets say you have a table with col1,...

SQL Server will not let you access files over UNC path; it must be local on the server.

If you need to access it remotely better to attached it SQL Server...

scott 52869 (9/2/2010)

---

Thanks again for you help with this Mohit.

I am having trouble finding the exact syntax on the sp_detach_db command in VB6. Here is what I am trying...

That's a good point, I'll have to remember that for future. I script out login name/db relations and db attached on each server for my DR. Never thought about...

In that case your new server should have been built to same patch level before doing the restore. If you don't have it documented what the patch level was for...

In my personal experience I have never had to shutdown SQL Server before restarting OS. SQL Server is very good at handling recovery.

I have never read or heard of...