In addition to Andras comment, in the event of a failover the sql 2005 which is currently the secondary server will become the primary server and once everything is fine...

It seems there is a mismatch in the LSN as a result the t-logs are unable to be restored........you need to restore all the t-logs from source to destination server...

I think you can get the info from the below system trables,

http://msdn2.microsoft.com/en-us/library/ms190355.aspx  but if you have a log shipping monitor configured it will store the info of which was the...

Hi Sathya, can you pls confirm that the path G:\Sql\logshippingfile exist i think either the path might be incorrect or the sql agent service account in secondary server might not have...

If you want to move your master which is currently in D:\drive to C:\drive you need to perform as shown in the below link,

http://sql-articles.com/articles.php?pageNum_alltop=5&totalRows_alltop=35

just click on the topic "Moving...

Hi Chris,

 We have configured database mirroring with 3 instances in high availability mode and hence witness server was included........I hope you can make the necessary alterations from the article and...

Chris, I dont think so.....you can take database snapshot of the mirror db if you have enterprise edition of sql 2005 installed in mirror server........

if you need to upgrade an existing instance of sql server you can make use of INPLACE UPGRADE.......it will overwrite the existing sql instance directly for that you need to...

Restore database DBname from disk='path of full backup' with norecovery

GO

Restore log DBname from disk='path of Tlog backup @9.00' with norecovery

GO

Restore log DBname from disk='path of Tlog backup @10.00' with norecovery

GO

Restore...

Hi Chris,

let me explain each of your questions as far as I could............

1. It is not a problem if the backup sometimes takes more than 5 mins........if the backup is not...

As Greg as rightly pointed out "do not delete the log files" then the database will go to suspect state and you cannot access it anymore........better you can truncate the...

In the above link you can see the heading "operating system requirements"

beneath that you can very well see Windows Vista and the second column in the table is enterprise edition which...

I think you need to specify the file growth in MB instead of percentage as the file is growing enormously.......if you specify the max file size to 300 mb it...

first truncate the log file and then perform the shrinking as it will free the space to operating system once you truncate the log file,

1.) backup log database name with...

I dont think there is any particular order for the restore process.....you can restore user db and then system dbs........well you can perform these disaster recovery between 2 sql 2000 servers...