The use robocopy to mirror the folders(incremental) from PROD to DR system.

These folder sometime use to host ssis pacakges,config files and other application files.

The job runs once and the DR...

thanks a lot. still i would prefer to have some simlified templates.

Well if your hardware on NetApp life becomes very easy .

You can use NetApp's SMSQL /sanpmirror/snapvault to replicate it to DR site.

In your case the databases are in...

yes the account is added in the lock pages in mem.

Do you guys think a cal to ms would be worth?

even the working set for SQL is showing 34 gb not sure why the task manager still shows 310 mb

Yes i happned to encounter a similar tape backup and also sometime the AV locking the files.

ok another twist, if i install 3 different instance on the devdbsrv1 will that still hold good.

You can use 7Za a nice standalone tool from 7Zip family.

the synatx is simple

7za.exe a myzip.7 *.bcp >>compress.log

if you find things are asynchronus try calling the batchfile from mater..xp_cmdshell...

oops i got it other way so removing the contents.

also check for Blockings and neverthless I/O.

Hope you have tried rebooting both the nodes.

Is sqlcmd working for you from the box?

wowwwww....

thanks a lot.

Steve i actually have a store proc which queries the metadata daily and gets the information in a history table. from this table i need to write a query which...

thanks again for all your inputs.

I am sure i will be able to convince business to wait for some more time and get on to SQL 2011.

thanks and i was glad to hear that SQL 2011 is in pipeline .we are at 2005 so i guess i should wait for some more time and then move...