Do you have row versioning (ALTER DATABASE SNAPSHOT ON)? Run this to see if its on....

Use Master

go

SELECT name, snapshot_isolation_state,

snapshot_isolation_state_desc AS description

FROM sys.databases

WHERE name =...

If you decide to detach rename and reattach instead - watch out for this issue that bit us when we ran it with SQL Agent job steps:

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

Who ever...

If I change the backup compression in sp_configure to 1 (0 is default), will it use compression on all backups?

Thanks,

Mary

What download of SQL2008 are you using for your backup example? My Feb CTP is 10.0.1300 - will your example work with the Feb. CTP?

Thanks,

Mary

Here is a paper from dell and microsoft.

http://www.dell.com/downloads/global/power/ps4q07-20070555-Chen.pdf

The appendix on this one is good:

http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/PhysDBStor.doc

Hope it helps.

Mary

Check out Joe Toscano's suggestions on Try...Catch regarding error messages with SQL2005 instead of using @@error:

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1180620,00.html#TRY

P_Insert_New_BookTitle_2K5

----------------------------------------------

create proc P_Insert_New_BookTitle_2K5

(@TitleName nvarchar(128),

@Price money,

@au_fname nvarchar(32),

@au_name nvarchar(64),

@CommissionRating int)

as

declare @err int,

@tablename sysname,

@errormessage...