That does sound long. I think SQL_ORACLE is right. I'd expect a 200GB file to be restored in 3-6 hours tops. If you have spread out the disk I/O, data,...

Stop using sa

No other way. Use a limited user, even a standard one, that has rights, like db_owner to particular databases.

Right click the database in Enterprise Manager, select Backup Database. pick a location and file name.

You can also setup a maintenance plan, select all "system dbs" and configure the backup...

This (http://www.sqlservercentral.com/columnists/rpearl/abitabout64bit.asp) seems to indicate you still need PAE and AWE. The data cache gets all your RAM, but the buffers for structures and objects are limited to 4GB.

Not a...

Scott and Cliff have really answered well, so listen to them and thanks for the great answers.

The only other hting I'll add is that the query optimizer works better with...

What is "Reseter Database" and I'm not sure what the list of server roles has to do with you attaching a database. If you are connecting as a sysadmin or...

The log stores all your transactions, which could be more than the data size, depending on how things are loaded.

If this was a one time, or rare thing, you can...

USE is a statement. I suspect that your BOL is out of date. There have been 2 or 3 updates to BOL since the release. CONNECT is a permission required...

Thanks for the complements! We try and please let us know when we stray off the path.

Steve

Congrats Sarah and good luck in the new position!

I'd do Profiler and Permon (System Monitor) to cover the time frame to start.

You can get Enterprise Manager from the SQL Server 2000 CD. Install the client tools. There's a 2nd disk in there that contains the Personal Edition, which you get iwth...

How are you loading the data? Typically I'd insert a row on the start and populate the name, "n", date, 0, getdate(), null.

Then after completion, update the row (based on...

Hope it helps. Remember to that unless you track it regularly, like every day, you won't know when it changed.

It's not a problem, but it is a sign of poor coding. Somewhere there is a commit statement, which ends a transaction, without there being a BEGIN TRANSACTION statement. It...