While it may be possible to implement tape in a log shipping application (I don't know), it seems to me that it is not desirable.

If your log transfers are frequent, I...

What do you mean by DR solution?

GaryA

Patience please, but I don't understand.  Where/what error message?

GaryA

I don't know if the following procedure is the best procedure, but it may work.

1.  Rebuild the master file.

2. Put Model and MSDB .mdf & .ndf & .ldf files back...

I would like to get the scenario correct.

a.  SQL Server was executing

b.  Model and MSDB were detached

c.  SQL server was shutdown

d.  Now SQL Server will not startup.

How you tried starting...

My thought process goes like this.  Since you upgraded your OS you may want to install a current version of MDAC on the clients and/or upgrade client components (fixes, or patches)

GaryA

I jump the gun with my last msg.  The obvious, maybe, would be to take a current backup of the production DB and proceed from there!!

Sorry

GaryA

First many thanks to Paul for providing access to an excellent article on Log Shipping.

Muneeb,

First let me state the obvious.  As I read the article Paul references, the thought occurred...

First many thanks to Paul for providing access to an excellent article on Log Shipping.

Muneeb,

First let me state the obvious.  As I read the article Paul references, the thought occurred...

Hi Muneeb,

Please let me verify.

Friday a production server was backed up and then restored to your standby server.  The production server recovery model was "full".

All logs created after the Friday...

I used to work in an environment which used three different scheduling systems.

I did not convert my SQL Jobs to either run on the mainframe nor through a 3rd party...

Another obvious appraisal.

Say a single backup is performed on the production server and it becomes the starting point for your standby server.  Then you ship logs for three weeks (maybe...

Angela is correct.  SQL Server backups are trustworthy and reliable.

As for the third party products, I believe they use SQL Server API's because they can NOT be reliable or trustworthy...

I also am a newbie, but I believe the command should be RESTORE HEADERONLY ......

Check BOL.

GaryA.

I am a newbie, but from what I read it seems the following should be true.

A full restore is performed on the standby server using the "norecovery" option. This allows...