most people use the script found in BOl, here:

http://technet.microsoft.com/en-us/library/ms188917(SQL.90).aspx

you will just have to add a further filter on object_id or tablename depending on what works best in your environment. I...

At a guess behind the scenes the alert logic works on the DBID of the database rather than the name, and when you created mydb_prod after deleting testdb_prod it ended...

set up log shipping through the wizard for just one of the databases. then use the 'script configuration' button for primary and secondary to create TSQL script for the setup...

and SSC pays off again. I've got a couple of scripts that suffix dates to filenames I'm going to alter (anything to save typing).

SELECT CONVERT(CHAR(2), GETDATE(), 3) for day of...

simialar thing:

right('0' + CONVERT(varchar(2), datepart(mm, getdate())),2)

Unfortunately thats not possible. For SQL2005 and below you have to uninstall and reinstall to remove a service pack.

It is a worthwhile practice to have backups of your resource database...

yep, logshippng is only HA solution that fits all your present requirements.

If you are on enterprise edition and are prepared to move test db to a different server you have...

going from the previous posts I believe we are ok...

yes I saw that Roy, I took it as a mistype or language barrier thing because it did not tie in with original question.

worth a check though,mirravi19, do we understand...

sounds perfect for logshipping then.

ship to the same server to a database of a different...

what is the target database you are currently trying to replicate to being used for?

asked and answered here................

http://www.sqlservercentral.com/Forums/Topic712821-145-1.aspx

I'd agree with Gail.

Only circumstance that should prevent choosing 2008 over 2005 now is if third party vendors won't support 2008.

2008 was almost a replacement for sql2005 SP3 so is...

good, straightforward question. Always worth re-emphasising that backing up a log does not shrink it.

Thankyou for that thorough explanation happycat.

As a production DBA who doesn't actually use SSIS or VS\BIDS (much) I have been more concerned with disaster Recovery and unloading packages out of...