hi,

could you give me details,

what is different between incremental backup & differential backup in sql server 2000?

Thanks for reply

i got file format with help of your script,

DVM_DB_Tlog2008-09-29_173509.TRN

.. its ok fine,

TLog Backup has been taken with date, but i need date and time becuse all Tlog overwrite the same file.

as per script file format is

D:\BackupDB\Tlog\DVM_DB_Tlog 2008-09-26.TRN

I want with time...

thanks for reply..

yes, we have

hi thanks for replay.. i am new sqldba

what i am asking, before shrinking .ldf file 99GB, and full backup size is 182GB, ok

after deployed the the following command

BACKUP LOG dblive...

sorry for the dealy...

Now i got clear idea.. so i will be make configure the daily differential backup and one full backup on every sunday and everyday at 1 hrs...

thanks for reply.. i am new SQL DBA

If i take full backup on sunday, so recovery model should be Full. ok

But if i take Incremental backup (simple), so recovery model...

RAM size is 1GB in secondary server

Actually this is secondary server with configured merge replication, so i have checked last day on replication jobs but its showing unsuccessfully, i think this is main problem of keep...

thanks for your valuable reply

Now restore was solve

i refreshed sql server view and tried stop and strat sql server service, still showing loding conditions......

thanks for reply

after restoring Database still keep on loading conditions,plz tell me what is actual issue?