Backup from 2000, restore to 2005... 1

[Neil Toulouse]

Hi!

Before I delve into testing this properly, could anyone tell me if it is possible to restore a DB backed up in SQL2000 to an instance of SQL Express 2005?

TIA
Neil

I like work. It fascinates me. I can sit and look at it for hours...

 

[mrdenny]

Yes you can. The only limit may be that the database probably needs to be below the 4 Gig size limit of SQL 2005 Express edition.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Neil Toulouse]

Thanks MrDenny!

Have tested it now and works fine!

We have a client who is trying to do exactly the same thing (with the same backup file as we have used) and all they are experiencing is the machine locking up during restore procedure (they don't get off the 0% mark). I have asked them to check the disk space is sufficient for the restore, but is there anyhing else that could be causing the machine to hang? (they have tried another 2005E instance on another machine but get the same problem).

TIA
Neil

I like work. It fascinates me. I can sit and look at it for hours...

 

[mrdenny]

If there isn't enough disk space to do the restore it will fail at the beginning of the restore saying that there isn't enough space and how much more space is needed.

Are they doing the restore via a T/SQL command or via the GUI?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Neil Toulouse]

Hi Denny!

It is being done via the GUI. However, they tried again last night and for whatever reason it worked!

Just one of those thing I suppose!

Neil

I like work. It fascinates me. I can sit and look at it for hours...