Can I restore SQL Server 2005 backup to SQL Server Express 2005

Can I restore SQL Server 2005 backup to SQL Server Express 2005

Post by ZGJyb29 » Sat, 03 Mar 2007 13:06:00


I have a backup of a SQL Server 2005 DB. Can I restore this to an instance
of SQL Server Express 2005?
 
 
 

Can I restore SQL Server 2005 backup to SQL Server Express 2005

Post by Strid » Sat, 03 Mar 2007 13:10:52


Provided it's smaller than the DB limit of SQL Server Express (which I
believe is 4 gig).

 
 
 

Can I restore SQL Server 2005 backup to SQL Server Express 2005

Post by Hari Prasa » Sat, 03 Mar 2007 21:40:12


Yes, You could well restore a SQL 2005 database backup in SQL Express
edition, but the limitation
in SQL express is 4 GB data size.

Thanks
Hari