Also, there is no native compression available in SS 2005. Time to backup and recover is much quicker with this tool and much easier to initiate.

David

We are currently trialing Idera SQL Safe for compressed backups.

Gail, I think that is the kicker. From time to time BI will need to add indexes on the secondary database. How would we accomplish that?

David

Thank you Gail. So just to clarify, if I set up LS, I can schedule a time after hours to copy over all the transaction logs and apply them...

Also, if I were to set up database mirroring and snapshot the mirrored database each night, is the snapshot something relatively quick? Also, does mirroring have any impact on...

Would we be able to add new indexes to the target database once it is in LS mode?

That would be the easy solution except for the time it would take to restore. Unfortunately I am not able to test a restore due to hardware constraints at...

Gail, thank you for chiming in. You know, I forgot about log shipping and that may be a better option. What we need to do is provide our...

Luis, this works perfect.

Thank you,

David

Clare, no worries. I should have been clearer explaining my request and situation. Thank you for chiming in.

I am merely trying to get feedback on using the DBCC SHRINKFILE EMPTYFILE command, hence the title of my post. I am not referring to my PRIMARY file. ...

I used the REPLACE function and it works as expected. Here is the solution I used:

SELECT

x.labtest_key,

x.ng_labtest_key,

x.labtest_desc

m.ng_labtest_desc

FROM

lab_tests_xref_tbl x INNER JOIN lab_tests_mstr_tbl m ON x.ng_labtest_key = m.ng_labtest_key

INNER JOIN...

Worked perfect. Thank you!

David

Can this be used in a stored procedure? I am trying to use the following and getting an error:

WITH BaseData AS (

SELECT

person_id,

...

Perfect. Thank you!

David