Restoration Problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Restoration Problem

Author

Topic

a.rameshk
Starting Member

19 Posts

Posted - 2007-07-09 : 11:12:23

While I am trying to Restore the Database in SQL Server 2005. From the Devise ‘F’. I am getting the Below Error. The Syntax which I used is given below.

Can I increase my Database Size.Though it is exceeding My licensed limit.

Can you clarify me.

restore filelistonly from disk = 'F:\Ramesh.BAK'

restore database Ramesh from disk = 'F:\Ramesh.BAK'
with move 'Ramesh_Data' to 'f:\Ramesh_Data.mdf',
move 'Ramesh_Log' to 'f:\Ramesh_Log.ldf'

Msg 1827, Level 16, State 4, Line 1

Error:CREATE DATABASE or ALTER DATABASE failed

because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Thanks & Regards
Ramesh.M

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-09 : 11:24:13

Sql2k5 express has 4gb db size limit.

a.rameshk
Starting Member

19 Posts

Posted - 2007-07-10 : 00:09:13

I am trying to Install it in Express Edition Only

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Kristen
Test

22859 Posts

Posted - 2007-07-10 : 03:28:54

"I am trying to Install it in Express Edition Only"

That's what rmiao is saying - looks like your Backup was made from a database that was bigger than 4GB [i.e. its files were bigger than 4GB regardless of how much/little data it held], and thus cannot be restored onto the Express edition.

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources