Thanks for the reply..

In how many ways the database will be crashed?

in which cases it can be recovered and in which cases it can't?

i have to audit changed data..

tell me which is best one(triggers or cdc) to use regarding performance issue..

full backup every 4 hrs..

thank u ..

Actually i'm taking backup for every 4 hrs.. with in 4 hrs if database crashes then i have to lose data if SQL server should not run(as...

thanks for reply..

my doubt is

what if the server is not running and database is not connecting?

then how to take tail log backup..

i have an old backup..

i have modified database after that backup.

what about that data(modifications)?

i want that data(modifications) also..

i don't want to move backup file manually..

is there any other way?

hi pradeep

is there any other way?

i have to take backup of database in public network system..

that backup file should be in my system..i.e local network system.

share folder is not...

actually system A is in LAN and system B is in public network..

is it possible to access a folder in system B from system A?

hi pradeep

the path is not accessible for me.

in start and run also it is not accessing..

and in public network shared folder is not accessing..

if i give normal folder in d...

Hi pradeep

i have try this one.

but it shows can not open backup device.

i have given same path as given to local network backup.

when i have given same path to local...

Hi pradeep,

i have another problem..

i am connected in local network..

previous problem is backup within the local network..

but now i have to take backup of public ip system.

how is it possible?

Thanks alot pradeep..

its working fine..

Hi

i got the following error.

The job failed. The Job was invoked by Schedule 2 (CollectorSchedule_Every_5min). The last step to run was step 1 (stepname).

Executed as user: server A....

Hi pradeep,

i did like this but it was not working..