Hiya,

No, you can't backup a database that's in recovery, but that's OK - you already have a backup because of the logshipping.

Cath

You need to talk to whoever is responsible for the dmz, they'll know the enabled ports and anything else you might need to know in order to connect. Procedures...

Hi,

Port 1433 will be blocked. If a machine is in a dmz there's a good reason for it - not using the default port adds to the security. ...

Hi VB,

SELECT CAST('20070101' AS datetime)

result: 2007-01-01 00:00:00.000

Cath

Hi Jerry,

A full backup on the primary server won't damage log shipping. A full backup on the secondary server will break the LSN chain, so don't do that. ...

Yes, that should sort it.

Cath

Hi Nabil,

The first error message is telling you that there's a log backup missing: 'the transaction logs are too recent to apply to the secondary database'. It also...

Hi Nabil,

Do you have log backups (not the logshipping ones) running over night? If so, that explains the message you received as the LSN chain will have been broken...

Hi,

This sounds like a DNS issue. I'm not a network expert, but if that's the case, the link between the server names and the IP addresses has been...

Hi,

Even on a non-prod server, deleting .ldf files is a bad habit to fall into as a general practice - they provide for the consistency and recoverability of your databases....

Hi Jon,

Try downloading MSDE from the MS site - it's the SQL Server 2000 equivalent of SQL Server Express.

Cath

Hi,

Have you checked that your database isn't in Simple recovery mode? You can't backup the log if it is.

Cath

Hi,

You won't be able to perform a transaction log restore unless you've already restored the last full backup with norecovery. There is a lot of information about log backup/restore...

Hi,

Maybe someone's scheduled sp_delete_database_backuphistory to run after the backups complete?

Cath

Hi Anjan,

Right click over the SQL Agent node in Management Studio and select Properties. Under the History tab there are settings relating to job history. It's possible someone...