Basically you're looking at using backups to archive old databases. There's nothing built-in to SQL Server that let's you do anything intelligent in terms of archiving - you need to...

Well, its broken. When you do a revert there's nothing entered into the restorehistory table. The only way to tell that a database has been reverted is to look in...

Looks like its squarely an issue with your IO subsystem. I'd get onto NetApp and have them help you diagnose the problem.

The quality of support has gone way down - I used to constantly battle incorrect support engineers (a lot easier to do when you're running one of the dev teams...

#1 - Absolutely not. Once a database is upgraded to the latest version, it can't be reverted to a down-level version

Yes, you can upgrade directly from 2000 to 2008.

Well, it depends 🙂

RAID 5 pays a penalty for writes so isn't suitable for OLTP systems, for instance. RAID 1 is fine unless you want high capacity or high speed...

I would move to Kimberly's favorite architecture of having a single table with current, read/write data - plus a partitioned table with older read-only data, with partitioned views over...

I am the source. I helped deprecate it when I ran the SQL Server Storage Engine dev team that wrote the new code for SQL Server 2005.

From Books Online in...

Cool.

By all means install SQL on the C drive, but don't fall into the trap of putting the data and log directories for any databases on the C drive too....

The only thing I can think of is that the SQL statement completes before the file system has really finished dropping the file - which shouldn't happen. Could be a...

I'll second what Joe says above. In the last few conference workshops I taught in November I was asked that question and did a poll of the attendees (1-200 in...

If you're on the machine that has SQL Server on, and there's a default instance, try one of the following:

sqlcmd /E

for integrated security, or

sqlcmd /Uusername /Ppassword

for SQL Server security. If...

It depends 🙂

What do you mean by 'faster'? Sure you may get a slightly faster response time if the app is on the same server as SQL Server instead of...

One last thing on MS - it's a very big company, with lots of groups. Anyone can sponsor a whitepaper, write a blog post/MSDN article/technet article and publish it, or...