Excellent - thank you for the help - much appreciated!:-)

Hello - we did try and name the database differently on the destination server - but I think we also tried naming it the same - I'm meeting with the...

I will read the whole page next time - thank you for your help.

There is a seperate dev & production area. The login is for an application using SQL Server authentication in a web.config file for the application to connect.

Thank you for sharing

Dave

Thank you for all of the replies - is there an exception if the sql server authentication is only being used by an application?

I expect the answer is "no" but...

Thank you for all of the good advice on this thread. I appreciate the time spent.

Thank you - that was the phrase I needed (cumulative updates)

I also see that some people have the opinion to wait for service packs

http://www.sqlservercentral.com/Forums/Topic1486749-391-1.aspx

http://ask.sqlservercentral.com/questions/7940/cumulative-updates.html

Thank you for...

Thanks John - I only had one situation where I tried importing records, got the constraint error, dropped the constraints, added the records then recreated the constraints - I don't...

The BAK files are delivered on an external drive. They are large so when I copy them over, I have to overwrite.

The BAK files always have the same name.

This time...

Thanks - but I overwrite the BAK file with a more recent one and always have it in the same directory.

Is there anything in the database that shows what BAK...

Thank you for replying - I found this link

http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.5500.0

I'm not sure if it was from the boot log after applying SP2 or SP3.

I'm not sure what is involved...

Its a backup to tape - he is not stopping the db and copying a file - its the backup command for the t-log.

He uses netbackup.

Thank you for explaining - I don't have VM experience yet.

With these posts I'm able to see the potential risks of continuing to run SQL2K, but what are the current...

"It's also possible you can't get a VM to operate within a newer system"

Can you explain this sentence more?

These servers are currently virtualized - how would it make a difference...