Part of the problem is the <>, which can make you scan the entire table. Plus this can be a large commit, lots of log space required, and more. Typically...

Craig Farrell (4/13/2011)

---

Steve Jones - SSC Editor (4/13/2011)

---

At one point we had a page peel there that opened and covered up the entire screen. I think it was from Quest,...

NTBackup should work, though you need to test. If you haven't restored to another machine, you are potentially not doing your due diligence. If you cannot restore those backups when...

People like to think, so if you can make them apply knowledge without memorizing some answer, it's a good question. Hard to do well, and going off forum posts is...

Excellent advice from Jim above.

Service Packs fix things, but if you are not having issues with any of the things addressed in a service pack, then you don't need to...

At one point we had a page peel there that opened and covered up the entire screen. I think it was from Quest, but it was definitely a $$$ thing....

Realtime backup is going to require some work. And money.

There isn't a good way to do this in SQL 2000. you can do log shipping, where you restore your...

Dwayne Dibley (4/13/2011)

---

As with most SQL questions -...

Since I need to track backups occurring, getting the size is simple and doesn't involve querying anything else. Seems simpler to me.

Nice question. It seemed clear to me also that you needed to account for different language or format settings.

First, create a role for this. Don't use individual users.

second, this script can help. Grant the permissions to the role, add the users to the role.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31186/

I like Jason's advice here. Duplicate your work on the newer version, get some practice with things.

Be sure you look at how you can rewrite some code in 2005/208 with...

6.9382384tr

I tend to do what the ninja does. Track database full backup size history. That will tell you what the growth is and what your data size, at least close...

Eric M Russell (4/12/2011)

---

Just for clarification, I didn't intend to compare fellow developers who occasionally code ad-hoc SQL to those other guys (idiots) who make u-turns on the interstate highway....