Thanq ROOKIE

but thing is like this

Database in full recovery model,every day morning iam taking fullbackup,and every hour iam taking translog backup,in evening ofter taking 4pm backup(transbackup),system crashed at 4:45pm,but thing...

Hi MAX

i have Q,

1)what edition u have in you system(ent or dev,std)

2)r u deatached mdf and ldf or what way u get mdf and ldf

chat me on sponguru@yahoo.com

Yaaa..

u get all commited trans between

10:00 to 10:30

in fullbackup

Yes the same

rpl please

Mr Pavan Mr.Rudy komacsar

may correct

DBCC SQLPERF(LOGSPACE)

pls check your SQL server Version

if it is Entripriser

it management->database management plans-

->right click on database management plans

-->at selectdatabases at down side u will get logshipping option

Try SELECT * FROM SYSFILES

may help u

How to calucalate t-sql query performance using executive plan and trace tools

i.e i have two same databases one with indexed one with non-index both having data(laks of records) so, i have...

NWLink IPX/SPX default port is 33584,

But it printed 33854 at QOD(23-06-2004)