Go through the following link

http://www.databasejournal.com/features/mssql/article.php/3556461

Although this link is not for gzip but you can get an idea of how to use this compression utilities with sql server.

Hope...

Kathy,

Please check sql server memory and processor utilization(for sqlservr.exe as well as for os level processes) counters under perfmon.

Manu

Paul,

Just execute sp_removedbreplication 'newdatabasename' on this newly restored database.

Let me know if this helps.

Manu

Thanks for the prompt reply Adam. I just wanted to confirm about how are you going to deal with sql logins, nothing else. I do agree that sp_help_revlogin script is...

Try running DBCC opentran just after running DBCC SHRINKFILE with emptyfile statement and check whether file is getting used during that time or not.

Also, try deleting the log file using...

Is your database getting used a lot during database backup operation? Check what are the other operations running on the same database during database backup time.

Also, is this disk array...

Hi Chris,

Is sql agent service started?

Regarding logging solution you can make use of logging options available under sql agent job and as well as dts package logs(can be saved...

Thanks for the detailed and useful reply Adam. I have one question here:

How are you going to deal with sql logins(in case they are there on live server but not...

http://www.red-gate.com/help/sqlbackup/Topics/SBU_CommandRESTORE.html

http://www.red-gate.com/help/sqlbackup/Topics/SBU_CommandBACKUP.html

For LiteSpeed restores, you can execute something along the

lines of:

EXEC master.dbo.xp_restore_database @database='YourDBName',

@filename = 'C:\PathTo\YourDBName_Backup.BAK',

@WIth = 'Replace'

There is also a GUI for LiteSpeed - try logging onto...

Just check whether any file related operations like Autogrow, autoshrink or any other backup statements are in execution in the background on this database.

Manu

Regarding memusage column I found this:

Pls note that BOL states that MEMUSAGE is only for backward compatibility and should not be relied upon.

The suggestion is to use perfmon...

Hope this helps for CPU question:

http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/detectingperformanceissueswithsysprocesses/2180/

Manu

Start the msdtc service if you want to use it on standalone instance. Normally its not required on unclustered instances but I read somewhere that its needed in transactional replication...

Lee,

Go through these and then come up with any conclusion:

http://support.microsoft.com/kb/325024

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1278729,00.html#

Hope this helps!

Manu

Try making use of sp_msforeachdb undocumented stored procedure.

Manu