so one more question

what will the below command do

BACKUP LOG P003 WITH NO_LOG.

where will the log file save.

Thanks a lot.

actually that drive only holds log files only. we have seperate drives for log and data files. and we take diff backups every day and once a week full backups....

It is full and i can never change it to simple since it is a Prod database.

but Chim, i want to grant on all the stored procedures. and by that process i can grant only one by one stored procedures.

ho do i

does he have execute permission on the procedure? He needs that, and control permission to modify it.

how do i do that, let me now please.....i need some steps

this is an urgent issue friends. please help me out.

But instead of coping over to server and then moving on the network path, is there anything to direct take a bak on the network path.

thanks a lot.

actually i have more than one databases............

any help is appreciated friends.............

and yes if if the script first create a folder by date every day.

but do you think that i can failover to windows server 2008, because my active node will still be windows server 2003?

any idea friends?