August 19, 2010 at 7:54 am
Hi,
Is it possible to restore a full backup created on SQL 2005 enterprise to a SQL Express edition?
Thanks
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
August 19, 2010 at 8:03 am
????????????:w00t:
August 19, 2010 at 8:05 am
It should be, providing the database doesn't use any features not supported in Standard and is no larger than the DB size limit on Express (4GB)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 19, 2010 at 8:16 am
Excellent!!! Thanks for the information, Gail.
I am getting an enterprise bak copy from a client this afternoon and I will post the results to this thread for future reference.
Thanks,
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
August 19, 2010 at 8:19 am
MostInterestingMan (8/19/2010)
Excellent!!! Thanks for the information, Gail.
Emphasis 'should'. I don't have an express instance around to try it out on.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 19, 2010 at 8:37 am
GilaMonster (8/19/2010)
MostInterestingMan (8/19/2010)
Excellent!!! Thanks for the information, Gail.Emphasis 'should'. I don't have an express instance around to try it out on.
Yep.
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply