Why did you have 10 instances ? Is there a business requirement for separate Instances ?

How many instances are active now ?

Can you combine databases onto the same instance...

No, you have to export everything to get from 2005 to 2000. If the target is in a remote place, you could install a local version of 2000, import data...

I hope...

You'll need to attach the log file too at the same time.

So after you browse for *.mdf and find "accounting.mdf", you should also look for "accounting.LDF". You will need both...

Are the search engines broken today ?!

http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

Do you mean striped ?

From http://msdn.microsoft.com/en-us/library/ms186865(SQL.90).aspx

Backup Devices in a Striped Media Set (a Stripe Set)

A stripe set is a set of disk files on which data is divided into blocks...

A simple question like that can be found in the documantation, along with relevant details:

http://tinyurl.com/ygxcgve

You only need to restore the most recent diff, then all the transaction logs...

And for an endless supply of unknown things, these forums are great !

Read the problems that we have, and try to find the answers so that things move from the...

Have you tried a 3rd party backup tool ? They compress the backup file about 80% and run faster than native backups. You can get a free triel to...

Are your other databases backed up ?

This might help show holes in your backup strategy:

http://www.mssqltips.com/tip.asp?tip=1601

And even after all that, I'm not even close.:crying:

If you retain backup history, that shows the data size before compression. Keep in mind that backups don't show free space, so you need to account for that as part...

Matt-1034261 (12/30/2009)

---

Hi Gail

Thanks for your suggestion, I tried restoring a new one from scratch, it got about half way and then came up with an error message to say something...

Transaction logs of production databases are usually backed up more frequently than you are doing. Are you sure you don't need them more often ? (I don't mean to...