Creating Database file greater than 2 TB.

Hi,
I need a database file greater than 2 TB. The disk size is 2.5 TB. But SQL
2005 is not letting me create a file greater than 2,097,152 MB. Is there a
way to increase the size of it.
Thanks,i think it sql2000 the max file size of a single database was 1TB. i
wouldnt doubt that would be the limit, but i havent installed 2005 yet.|||not wise to do that anyhow.
Just create more than one file in your filegroup. Is there a reason you are
only using one file?
Also, make sure you are running Windows 2003 SP1. There were issues in
Windows 2003 Gold with such large files.
"ray" <ray@.discussions.microsoft.com> wrote in message
news:1CBD741E-3B21-4EEB-A8E0-6D7A03F1BF53@.microsoft.com...
> Hi,
> I need a database file greater than 2 TB. The disk size is 2.5 TB. But SQL
> 2005 is not letting me create a file greater than 2,097,152 MB. Is there a
> way to increase the size of it.
> Thanks,
>|||try setting up Federated Databases and using partitioned views or
smarter sp's across multiple databases for your queries you have to
join across.

Creating Database file greater than 2 TB.

Hi,
I need a database file greater than 2 TB. The disk size is 2.5 TB. But SQL
2005 is not letting me create a file greater than 2,097,152 MB. Is there a
way to increase the size of it.
Thanks,
i think it sql2000 the max file size of a single database was 1TB. i
wouldnt doubt that would be the limit, but i havent installed 2005 yet.
|||not wise to do that anyhow.
Just create more than one file in your filegroup. Is there a reason you are
only using one file?
Also, make sure you are running Windows 2003 SP1. There were issues in
Windows 2003 Gold with such large files.
"ray" <ray@.discussions.microsoft.com> wrote in message
news:1CBD741E-3B21-4EEB-A8E0-6D7A03F1BF53@.microsoft.com...
> Hi,
> I need a database file greater than 2 TB. The disk size is 2.5 TB. But SQL
> 2005 is not letting me create a file greater than 2,097,152 MB. Is there a
> way to increase the size of it.
> Thanks,
>
|||try setting up Federated Databases and using partitioned views or
smarter sp's across multiple databases for your queries you have to
join across.

Creating Database file greater than 2 TB.

Hi,
I need a database file greater than 2 TB. The disk size is 2.5 TB. But SQL
2005 is not letting me create a file greater than 2,097,152 MB. Is there a
way to increase the size of it.
Thanks,i think it sql2000 the max file size of a single database was 1TB. i
wouldnt doubt that would be the limit, but i havent installed 2005 yet.|||not wise to do that anyhow.
Just create more than one file in your filegroup. Is there a reason you are
only using one file?
Also, make sure you are running Windows 2003 SP1. There were issues in
Windows 2003 Gold with such large files.
"ray" <ray@.discussions.microsoft.com> wrote in message
news:1CBD741E-3B21-4EEB-A8E0-6D7A03F1BF53@.microsoft.com...
> Hi,
> I need a database file greater than 2 TB. The disk size is 2.5 TB. But SQL
> 2005 is not letting me create a file greater than 2,097,152 MB. Is there a
> way to increase the size of it.
> Thanks,
>|||try setting up Federated Databases and using partitioned views or
smarter sp's across multiple databases for your queries you have to
join across.