You can restore from SQL 2000 to SQL 2008 R2, just not master, model, or msdb

http://msdn.microsoft.com/en-us/library/ms191253%28v=SQL.105%29.aspx

😉

Use compression. The native one, or buy a third party product that can get you more compression. It saves space, but it can also reduce the time a backup takes,...

You need an index on the 70 char key, regardless if it's the primary key. If you use it as the clustered index, then there isn't extra space created. If...

A 1000 SQL logins means more of a password management issue for the DBAs. A 1000 windows logins puts that effort on the Windows admins, or help desk. Also, if...

Others have explained what you need to provide, but I'll give you a few hints.

If you have the specified time interval, that should be in your WHERE clause, having a...

I usually set all job owners as SA just to avoid these issues.

Congrats, Gail.

I am not putting as much effort into the discussions lately with all the travel. Not likely to change, either, so I think that most of you will pass...

A fun question for a holiday. At least it was supposed to be for me, but a little behind.

It's a bit of trivia, totally useless, but we stick those in...

When you say unique to each instance, do you mean each instance on each node, or do you have multiple instances on the virtual clustered instance? The jobs on Node...

Indeed, congrats to the Cards. I had mixed feelings, and watched the final game Fri night, wishing it were closer. Sad to see the Rangers implode, hitting two batters in...

First, turn on more logging from plans or SQL agent. Use a log file.

By default what you have doesn't provide enough information to determine the issue.

A few questions. Are you...

If you create a physical user for each login, you are asking for a lot of administrative work to be done, unless you expect the application to create the user,...

The post above explains how to do it, but as a few people have said, there's no need.

SQL Server does not need cold backups. Ever. The online backup is rock...

Just a quick note. I have an iPad 1 and use a bedside charger station. It always says "not charging", but it charges, albeit slow. I can be down to...