Tuesday, March 27, 2012

Attach Database Basic Question


When one of our clients tries to attach a database (about 6GB in size)
she gets a message saying file size limit exceeded. She is using Sql
Server 2000. Is there a limitation on size for Sql Server 2000? I know
for MSDE the size can not be more than 2GB. Can you shed any light on
the issue please?Strange, and is there enough space on the file system for the database?
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1147856960.608383.244690@.i39g2000cwa.googlegroups.com...
>
> When one of our clients tries to attach a database (about 6GB in size)
> she gets a message saying file size limit exceeded. She is using Sql
> Server 2000. Is there a limitation on size for Sql Server 2000? I know
> for MSDE the size can not be more than 2GB. Can you shed any light on
> the issue please?
>|||Sounds like your client is using MSDE or SQL Server which has limit of data
storage for a database
(2 vs 4 GB).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1147856960.608383.244690@.i39g2000cwa.googlegroups.com...
>
> When one of our clients tries to attach a database (about 6GB in size)
> she gets a message saying file size limit exceeded. She is using Sql
> Server 2000. Is there a limitation on size for Sql Server 2000? I know
> for MSDE the size can not be more than 2GB. Can you shed any light on
> the issue please?
>

No comments:

Post a Comment