Database Size Limitations

Hey all,
Is there any way that I can find the current size limitation (eg, MSDE = 2gb
limit) of a database from a db query / DMO dll call etc?
ThanksYou can get the edition and product information with these:
SELECT SERVERPROPERTY('productversion') AS [ProductVersion]
SELECT SERVERPROPERTY('ProductLevel') AS [ProductLevel]
SELECT SERVERPROPERTY('Edition') AS [Edition]
But there is no bit that I know of that you can see for the size limitation.
It's pretty simple though if it is MSDE it is 2GB, if it is SQLExpress it is
4GB otherwise there is no limit.
Andrew J. Kelly SQL MVP
"-Ldwater" <Ldwater@.discussions.microsoft.com> wrote in message
news:9F961CBD-4303-49DA-A8D8-8E2C63296BB5@.microsoft.com...
> Hey all,
> Is there any way that I can find the current size limitation (eg, MSDE =
> 2gb
> limit) of a database from a db query / DMO dll call etc?
> Thanks|||Thanks Andrew, but which bit out of the server results would show what
version the DB is running on?
I understand which DB's have limits, but I cant establish a way to find out
which type of DB system is being used by our customers in order to impose a
limit check.
Any help would be great! Thanks!
"Andrew J. Kelly" wrote:

> You can get the edition and product information with these:
>
> SELECT SERVERPROPERTY('productversion') AS [ProductVersion]
> SELECT SERVERPROPERTY('ProductLevel') AS [ProductLevel]
> SELECT SERVERPROPERTY('Edition') AS [Edition]
> But there is no bit that I know of that you can see for the size limitatio
n.
> It's pretty simple though if it is MSDE it is 2GB, if it is SQLExpress it
is
> 4GB otherwise there is no limit.
> --
> Andrew J. Kelly SQL MVP
>
> "-Ldwater" <Ldwater@.discussions.microsoft.com> wrote in message
> news:9F961CBD-4303-49DA-A8D8-8E2C63296BB5@.microsoft.com...
>
>|||I am not sure i am understanding you properly. Are you asking how do you
determine if they are running MSDE or not? Is so then just run
SERVERPROPERTY('Edition') to see. You can check BooksOnLine under this
command for the proper results.
Andrew J. Kelly SQL MVP
"-Ldwater" <Ldwater@.discussions.microsoft.com> wrote in message
news:44A7095B-F895-49DD-AA34-28FFE7F4DC1E@.microsoft.com...
> Thanks Andrew, but which bit out of the server results would show what
> version the DB is running on?
> I understand which DB's have limits, but I cant establish a way to find
> out
> which type of DB system is being used by our customers in order to impose
> a
> limit check.
> Any help would be great! Thanks!
> "Andrew J. Kelly" wrote:
>|||Yeah, thats what im after.
When trying it out, ive got an MSDE installation locally and a full SQL 2000
on a server, but both return 'Developer Edition' from the 'Edition' server
property, so I assumed that this wasn't specific enough?
"Andrew J. Kelly" wrote:

> I am not sure i am understanding you properly. Are you asking how do you
> determine if they are running MSDE or not? Is so then just run
> SERVERPROPERTY('Edition') to see. You can check BooksOnLine under this
> command for the proper results.
>
> --
> Andrew J. Kelly SQL MVP
>
> "-Ldwater" <Ldwater@.discussions.microsoft.com> wrote in message
> news:44A7095B-F895-49DD-AA34-28FFE7F4DC1E@.microsoft.com...
>
>|||Hmmm. I can see the Full version showing Developer if that what it is but I
would expect MSDE to show DeskTop. Are you sure you were pointing to the
correct instance? What does "engine edition" show?
Andrew J. Kelly SQL MVP
"-Ldwater" <Ldwater@.discussions.microsoft.com> wrote in message
news:B68E0408-2DE2-4CEA-886A-00338CBA8645@.microsoft.com...
> Yeah, thats what im after.
> When trying it out, ive got an MSDE installation locally and a full SQL
> 2000
> on a server, but both return 'Developer Edition' from the 'Edition' server
> property, so I assumed that this wasn't specific enough?
> "Andrew J. Kelly" wrote:
>|||Ok.. im a dumbass! (Looking at the wrong DB!)
Now my 'Engine Edition' Shows 1 (Desktop Edition) which is what I would
expect.
Do we know if the 'SERVERPROPERTY(EngineEdition)' returns similar results
for SQL 2005 & SQLExpress?
"Andrew J. Kelly" wrote:

> Hmmm. I can see the Full version showing Developer if that what it is but
I
> would expect MSDE to show DeskTop. Are you sure you were pointing to the
> correct instance? What does "engine edition" show?
> --
> Andrew J. Kelly SQL MVP
>
> "-Ldwater" <Ldwater@.discussions.microsoft.com> wrote in message
> news:B68E0408-2DE2-4CEA-886A-00338CBA8645@.microsoft.com...
>
>|||These are the possible results from both the Edition and Engine Edition
properties in 2005 BOL:
'Desktop Engine'
'Developer Edition'
'Enterprise Edition'
'Enterprise Evaluation Edition'
'Personal Edition'
'Standard Edition'
'Express Edition'
'Workgroup Edition'
'Windows Embedded SQL'
---
Database Engine edition of the instance of SQL Server installed on the
server.
1 = Personal or Desktop Engine
2 = Standard
3 = Enterprise (This is returned for Enterprise, Enterprise Evaluation, and
Developer.)
4 = Express
Andrew J. Kelly SQL MVP
"-Ldwater" <Ldwater@.discussions.microsoft.com> wrote in message
news:24868DAD-04FA-42B2-BF4E-7571BF6DCB06@.microsoft.com...
> Ok.. im a dumbass! (Looking at the wrong DB!)
> Now my 'Engine Edition' Shows 1 (Desktop Edition) which is what I would
> expect.
> Do we know if the 'SERVERPROPERTY(EngineEdition)' returns similar results
> for SQL 2005 & SQLExpress?
> "Andrew J. Kelly" wrote:
>sql

Database Size Limitation of SQL Server 2000 Personal Edition ?

I would like to know is there any limitation to the size of data file of SQL
Server 2000 Personal Edition. Just like the MSDE, the data file size cannot
be greater than 2GB (From memory) ?No there is no limitation.
But there is limitation on RAM usage

Database Size Limitation of SQL Server 2000 Personal Edition ?

I would like to know is there any limitation to the size of data file of SQL
Server 2000 Personal Edition. Just like the MSDE, the data file size cannot
be greater than 2GB (From memory) ?
No there is no limitation.
But there is limitation on RAM usage

Database Size Limitation of SQL Server 2000 Personal Edition ?

I would like to know is there any limitation to the size of data file of SQL
Server 2000 Personal Edition. Just like the MSDE, the data file size cannot
be greater than 2GB (From memory) ?No there is no limitation.
But there is limitation on RAM usage

Database Restoration

Hi!
Could anyone please advice me on whether I could restore
database from a map drive ? This is due to space
limitation of the existing server...
Any other suggestions would be much appreciated..
TIAIt generally work (I've seen some issues with backup/restore over the
network, mainly for larger backups). Worth a try. Make sure that the SQL
Server service account has permissions on the share, and address using UNC
naming.
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> Hi!
> Could anyone please advice me on whether I could restore
> database from a map drive ? This is due to space
> limitation of the existing server...
> Any other suggestions would be much appreciated..
> TIA|||Could you provide me the steps cause i have tried it and
could not view the map drive from Enterprise Manager...
on NT4 platform MSSQL 7.0 server.
TIA
>--Original Message--
>It generally work (I've seen some issues with
backup/restore over the
>network, mainly for larger backups). Worth a try. Make
sure that the SQL
>Server service account has permissions on the share, and
address using UNC
>naming.
>--
>Tibor Karaszi
>
>"NG" <angiecmf@.hotmail.com> wrote in message
>news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
>> Hi!
>> Could anyone please advice me on whether I could restore
>> database from a map drive ? This is due to space
>> limitation of the existing server...
>> Any other suggestions would be much appreciated..
>> TIA
>
>.
>|||Don't use mapped drives, just enter the path as an UNC path:
\\servername\sharename\filename
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
> Could you provide me the steps cause i have tried it and
> could not view the map drive from Enterprise Manager...
> on NT4 platform MSSQL 7.0 server.
> TIA
> >--Original Message--
> >It generally work (I've seen some issues with
> backup/restore over the
> >network, mainly for larger backups). Worth a try. Make
> sure that the SQL
> >Server service account has permissions on the share, and
> address using UNC
> >naming.
> >
> >--
> >Tibor Karaszi
> >
> >
> >"NG" <angiecmf@.hotmail.com> wrote in message
> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> >> Hi!
> >>
> >> Could anyone please advice me on whether I could restore
> >> database from a map drive ? This is due to space
> >> limitation of the existing server...
> >> Any other suggestions would be much appreciated..
> >> TIA
> >
> >
> >.
> >|||i encountered error "Unable to verify the existence of the
backup file location". Do you want to use the backup file
location anyway? and
Microsoft SQL-DMO (ODBC SQLState: 42000)
"Cannot open backup
device '\\Etax_media\temp\tna_sen.bak'. Device error or
device off-line. Backup or restore operation terminating
abnormally"
Please help! Thanks
>--Original Message--
>Don't use mapped drives, just enter the path as an UNC
path:
>\\servername\sharename\filename
>--
>Tibor Karaszi
>
>"NG" <angiecmf@.hotmail.com> wrote in message
>news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
>> Could you provide me the steps cause i have tried it and
>> could not view the map drive from Enterprise Manager...
>> on NT4 platform MSSQL 7.0 server.
>> TIA
>> >--Original Message--
>> >It generally work (I've seen some issues with
>> backup/restore over the
>> >network, mainly for larger backups). Worth a try. Make
>> sure that the SQL
>> >Server service account has permissions on the share,
and
>> address using UNC
>> >naming.
>> >
>> >--
>> >Tibor Karaszi
>> >
>> >
>> >"NG" <angiecmf@.hotmail.com> wrote in message
>> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
>> >> Hi!
>> >>
>> >> Could anyone please advice me on whether I could
restore
>> >> database from a map drive ? This is due to space
>> >> limitation of the existing server...
>> >> Any other suggestions would be much appreciated..
>> >> TIA
>> >
>> >
>> >.
>> >
>
>.
>|||The first message is some tool (or rather, API) message, not an engine
message. The second is an engine message. It seems that the path is
incorrect or that the SQL Server service account don't have permissions on
the share.
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:0aff01c3a2ab$d4f047d0$a401280a@.phx.gbl...
> i encountered error "Unable to verify the existence of the
> backup file location". Do you want to use the backup file
> location anyway? and
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> "Cannot open backup
> device '\\Etax_media\temp\tna_sen.bak'. Device error or
> device off-line. Backup or restore operation terminating
> abnormally"
> Please help! Thanks
> >--Original Message--
> >Don't use mapped drives, just enter the path as an UNC
> path:
> >\\servername\sharename\filename
> >
> >--
> >Tibor Karaszi
> >
> >
> >"NG" <angiecmf@.hotmail.com> wrote in message
> >news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
> >> Could you provide me the steps cause i have tried it and
> >> could not view the map drive from Enterprise Manager...
> >> on NT4 platform MSSQL 7.0 server.
> >> TIA
> >>
> >> >--Original Message--
> >> >It generally work (I've seen some issues with
> >> backup/restore over the
> >> >network, mainly for larger backups). Worth a try. Make
> >> sure that the SQL
> >> >Server service account has permissions on the share,
> and
> >> address using UNC
> >> >naming.
> >> >
> >> >--
> >> >Tibor Karaszi
> >> >
> >> >
> >> >"NG" <angiecmf@.hotmail.com> wrote in message
> >> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> >> >> Hi!
> >> >>
> >> >> Could anyone please advice me on whether I could
> restore
> >> >> database from a map drive ? This is due to space
> >> >> limitation of the existing server...
> >> >> Any other suggestions would be much appreciated..
> >> >> TIA
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >