usually differential backups treated as an incremental backups..i don't think both are different..

In sql server if anything modified after taking the fullback it will be recorded in page as...

Thanks john...i have changed my physical names ...it's working fine now

As per my requirement i don't want to keep the old backup files in my backupset..so how can i overwrite those backupfies in backup set.I have tried WITH FORMAT option...

when i try to execute below one

SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections,loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY ...

without stoping SSMS is there any other way ?

what am asking is if minimal information stored in t-log means how can we recover the data when we set database as bulk recovery...

hope u understand..

Thanks

I mean to ask that normal recovery not point in time

Hi gila..Thanks for reply(very helpful sites)

I had better if u will give our own words in short..

Thanks

How to check whether sql profiler is enable or not ..and reqired complete steps regarding creating trace and all for enabling the sql profiler

I used labelonly option but didn't get any information related to netbackup

Hi Gila,

Is Modified pages(located in log) were enough for doing restoration?

Thanks

Hi Gila,

Thanks for quick reply..

But Sorry Still am not clear...what type of data involved in modified pages..?

Thanks

Hi Steve,

Thanks...The link(regarding script) what you gave was really help to me..

But I have to modify as per my requirement..any way thanks to you.

Now i want to another script for...

Hi Steve,

Thanks for quick reply.

What im asking is i have an backup files already for multiple databases..

so based upon those .bak files automatically restore should happened using with move option.Database...

First you have to drop the built-in/administrators using

drop login [bultin/administrators] and then here after u shouldn't create an any logins related to windows account..so this is the one way...