thanks..GSquared...

thanks for responding...i mean this is just for testing the load on the database...like before deploying a db in prod we test on UAT..so inorder to get the reason for...

Hey Paul..i appreciate your suggestion...i do not have access to those servers and that server is not part of our group...the dev was just asking my suggestion..i found that he...

ok ..i will ask him to do...so then what would be the default size of the log file...thanks..

but the log file was assigned 270gb when the db is created...i don't think i can shrink the size of log file below 270 gb...and..if i just take a full...

excellent post...i have learned many new things...thank you Gail for sharing your knowledge with us..with this i just need to say one thing...one of the developers told me that he...

if i do a restore with no recovery...i do not think i can test the SSIS packages..since the db is in recoevery mode..so i will need to restore completely..then later...

the old server has sql2000 dbs..will log shipping effect the performance of the old server..thanks..

just an update...as i was mentioning before that all the jobs were copied from the source onto new server..but today i found that some jobs were not copied...i realize that...

i couldnt get what you are trying to say...the packages were migrated month back...i just see the jobs for the first time two days ago...the jobs were not there until...

thanks everyone for all your answers..

Rajni..i see the jobs...i do not think msdb is migrated bcoz in the porp it still shows the old date.

Jonathan..the packages were migrated long back..we...

for dbs backup & restore..and for DTS packages..i think the other guy did use BI studio...

hello thanks..i did check in the jobs owner..it is the same as the source...and all the jobs are transfered..how could someone unknowingly transfer all the jobs???..thanks again for ur answer...

thank you for your reply...Steve you do not suggest me to use dbcc freeproccache...bcoz i was assuming that wehn i migrated dbs and use dbcc freeproccache it will cache the...

ok...i was reading an article...dbcc is instance level..so on question is solved..but still the other question.?..