Restore backup set

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vijayakumar .Y - 24 Jun 2008 13:55 GMT

Hi all,
How can I restore a database backup set created from sql server 2005
developer edition to sql server express 2005?
Vijayakumar

Reply to this Message

Andrea Montanari - 24 Jun 2008 15:27 GMT

hi,

> Hi all,
> How can I restore a database backup set created from sql server 2005
> developer edition to sql server express 2005?
> Vijayakumar

as long as the database does not exceed the SQLExpress edition limit of 4gb
per database, you should be able to restore that backup on a SQLExpress
instance.. you can do it via straight RESTORE statement or via a graphical
solution like SQL Server Management Studio (Express, in case of the
SQLExpress edition, qhich is free)..

Signature

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply

Reply to this Message