you said you would like to give scheduling access to users in that case i will...

what makes you to increase the virtual memory?

what is the sql error log and windows log says at that time?

ASYNC IO looks like related to your backup place IO issue and nothing related to virtual memory.

is the backup gets completed?

Abu Dina (8/30/2012)What I want to say to the manager is that doing a full backup while people are still working is not an issue. SQL Server has the intelligence...

hope i remember u have space crunch issue for backup.

differential backup is to prevent data loss from the previous full bakup idealy good if it has been done in between...

thanks opc , we are on windows 2003 server and sql 2005.

hope i have to install powershell on the server to use it.

i never worked in PowerShell do i have to install somehting or am i missing something?

what services will be userd to tun XP_Delete_File. i dont know about that.

opc, i'll try that but how about deleting files on a date range basis.

any problem...

Joy Smith San (8/26/2012

Experts i need your advice on below,

if take a TLOG backup and keep it on the log shipping share drive will the log shipping happens without break?...

San, it will break the chain, but my question is why do need to back up the log if...

Joy Smith San (8/25/2012)

Do I need to backup log if log shipping is implemented in that database ?

Will the log backup taken by log shipping truncate the log file so...

it has write access as the job is creating the log files backup in the folder which is required.

in which services will the XP_Delete_File runs ,hope that permission might left...

what are you trying to do, are you trying to save the output of configuration sp's in the table and do some manipulations?

DBA level depends

is he/she going to take care of DB only.

will he/she take of storage/hardware for servers

kindly specify the details level for the DBA?