What is your SQL Serevr patch level? you can find out by "select @@version".

Is your database in full recovery mode and there is no transaction log backup at all? You may also have a maintenance job to rebuild the indexes.

dbcc sqlperf(logspace) will tell...

Run "select count(*) from sysobjects where xtype = 'V'" on your original database and the database you restored.

In your backup command, you create the backup in "DISK = N'D:\Backup\ADPPROD.bak' "...

dbcc sqlperf(logspace) tells you the log szie and percentage of used.

In order to start/stop services in server A, you have to be the member of local administrator group in that server.

Congratulations Frank! You deserve it for your hard working.

Allen

Run SQL Server Profiler for a period of time to capature the stored procedurs which have been used and use the list as filter to find out which stored procedures...

Do you have security patch ms04-011?

Do you see any related warning/error messages in system log ?

How long was the CUP in high usage after developers connecting to virtual SQL Server with...

Jeff,

Do you know how many tables involved the replcation in this 100GB database and which tables are out of sync?

You have to re-attach your dataabses to SQL Server after it is reinstalled. Check BOL sp_attach_db command.

Do you see any databases by running sp_helpdb from Query Analyzer?

run "dbcc inputbuffer(your_long_running_process_spid)" and post the result back.

Check BOL about grant permission to objects.

It sound like you have connection issues. Try login in the server see whether you can select the table.

Cody,

"when an intergity check is performed, the database goes into single user mode."

Above is only true if the database integrity is checked with repair option. Otherwise, Users are still able...

The BUILTIN\Administrators   logins is there, so just change the registry , restart SQL Server service, login the server with either domain or local administrator account, registry the SQL Server with...