HI Muthu ,

Good script given.

HI muthu, i have a Dought in Sqlserver2000 , IN sqlserver 2005 Copy_only option is there But In sql server2000 not there if hava log shiping or Replication iam using iam taken backup lsn chain will breakup.

In my production sqlserver2000 is there how to take a backup without lSN Breakup

Thank You

Harishkumar.M