database name is OK. The file names have got an extension of _NEW.

Well. This is thru. But with a problem. The database restored on secondary server has got an extension of _NEW. Example DBNAME_NEW.mdf

This will not serve the purpose for failover. Any...

I m using sa login for configuring logshipping. No reason why sa will not create job on secondary server.

please help. I m totally clueless.

The highest version i need to connect to is sql 2008 R2 enterprise 64 bit, so do i need the same for monitoring server or sql 2008 standard edition 64...

Makes sense. Thanks again.

Thanks Anthony.

Can I connect to sql 2008 enterprise\standard editions using this express client?

I want to check backups on all servers by connecting from this client. As I know, i cant...

Thanks Antony.

I cant rename the alpha db, because once in a while this has to be restored from recent full backup of alpha.

Thats why i am going with a named...

Select distinct top 1 ...

RESTORE VERIFYONLY

Please check whether the full backup of 'HealthLinx2010SQL' is actually a clean backup or not, i mean completed properly. A valid file.

Thanks Anthony. I have moved it successfully.

Thanks to both of you. This works fine.

Dwain's reply is very close to requirement, without AM\PM, but I think this is fine for the moment.

Heartly thanks to everyone for your sincere involvement.

Sorry Kshitiz, no luck yet.

Thanks Cadavre. Finally used your script as this was meeting my requirement exactly. Year wasnt required, only day and month.