Thanks I'll have to try it out

ok.. just what about licensing issues? On our desktops we do not use visual studio 2005... wouldn't we have to install that too?

So if we use "Restore database with Force restore over existing database" then we should be all good? If we did a straight restore, I believe the physical paths will...

It was highly recommended from the vendor to reinstall from scratch because they have 10 different filegroups splitting all the tables and their 1000 indexes. So if we did a...

We are using the RS print activeX to do all our printing, we rarely ever have anyone export to pdf or print directly to a pdf. The printers we are...

ok... then maybe we'll then move all the other 3rd party app processes to use the other processor.

Right we are aware of that... the question is it legal to point one sql server to run only one of the processor and point the other sql server to...

64bit would be nice but that would mean new hardware and software which is not in our budget for 2009.

We are running 2003 r1 enterprise. So thats a definite...

32bit... and no we do not have awe enabled.... we are running 2k standard and 2005 standard

For anyone out there... checkout this link from microsoft to fix 2k and 2005 Reporting services, Win2003 servers, XP, vista....etc for the Kill Bits patch.

Question though... has anyone run into...

Well one of the issues is that we want it to be in an automated job which gets the latest backup from say sunday night than to have someone do...

THis definitely what I'm Looking for to put in a job!

ok... I was leaning towards that... just the question is should I restore the .bak or can I restore the transaction log or logs?

kinda off the topic/ relevant question is: would fuel/gas mileage be higher if we neglected safety features that put more weight in a car and if we ditch all the...

Thanks for the input... depending I might attempt to adapt one of the scripts out there if we get serious on making the production server a differential. Overall, we want...