Any way to create 5KB size of Database?

Hi
when we create new database that will take base structure and size of the
model database. it will be approx 1.43 MB as per version. now i want to
create database that size is 5kb any way to create database like that size,
why the reason is for CD technolgy we have less space.. can u suggest me?
Thanks
Sriram.Srikanth
SQL-Server Database Administrator,
Hi
The newly created DB gets it's sizing from Model DB. Model DB can not be
made smaller. With all the structures needed in the MDF and LDF files,
1.43mb is the smallest you can get.
Why ship the DB? Create the DB though T-SQL code on the client machine.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>
|||What you could do is distribute the MDF file only, in a zipped version...
Then unzip it, and use sp_attach_single_file_db to load it up..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>
|||You could also simply distribute the create database/object script. This
would insulate you from physical changes to the mdf file, which is a risk
with the other way I mentioned.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>

Any way to create 5KB size of Database?

Hi
when we create new database that will take base structure and size of the
model database. it will be approx 1.43 MB as per version. now i want to
create database that size is 5kb any way to create database like that size,
why the reason is for CD technolgy we have less space.. can u suggest me?
Thanks
--
Sriram.Srikanth
SQL-Server Database Administrator,Hi
The newly created DB gets it's sizing from Model DB. Model DB can not be
made smaller. With all the structures needed in the MDF and LDF files,
1.43mb is the smallest you can get.
Why ship the DB? Create the DB though T-SQL code on the client machine.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>|||What you could do is distribute the MDF file only, in a zipped version...
Then unzip it, and use sp_attach_single_file_db to load it up..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>|||You could also simply distribute the create database/object script. This
would insulate you from physical changes to the mdf file, which is a risk
with the other way I mentioned.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>

Any way to create 5KB size of Database?

Hi
when we create new database that will take base structure and size of the
model database. it will be approx 1.43 MB as per version. now i want to
create database that size is 5kb any way to create database like that size,
why the reason is for CD technolgy we have less space.. can u suggest me?
Thanks
--
Sriram.Srikanth
SQL-Server Database Administrator,Hi
The newly created DB gets it's sizing from Model DB. Model DB can not be
made smaller. With all the structures needed in the MDF and LDF files,
1.43mb is the smallest you can get.
Why ship the DB? Create the DB though T-SQL code on the client machine.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>|||What you could do is distribute the MDF file only, in a zipped version...
Then unzip it, and use sp_attach_single_file_db to load it up..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>|||You could also simply distribute the create database/object script. This
would insulate you from physical changes to the mdf file, which is a risk
with the other way I mentioned.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>

any point in putting more than 2Gb ram in machine for standard edition ?

if a member server runs 2000 or 2003 with SQL server standard edition is
there any point putting more than 2Gb of ram in the machine ?
i.e i base this on 2Gb being the max for Sql server 200.
thanks for your advice
Scott
Standard edition is limited to 2GB so the additional memory won't be used by
SQL Server directly. However, the OS requires memory too so you should
consider this as well as memory needed by other apps. I usually spec 3GB
for a dedicated SQL Server 2000 running Standard Edition.
Hope this helps.
Dan Guzman
SQL Server MVP
"scott" <aintnoapmhere@.yahoo.com> wrote in message
news:%23T2POP72FHA.632@.TK2MSFTNGP10.phx.gbl...
> if a member server runs 2000 or 2003 with SQL server standard edition is
> there any point putting more than 2Gb of ram in the machine ?
> i.e i base this on 2Gb being the max for Sql server 200.
> thanks for your advice
> Scott
>
|||"scott" <aintnoapmhere@.yahoo.com> wrote in message
news:%23T2POP72FHA.632@.TK2MSFTNGP10.phx.gbl...
> if a member server runs 2000 or 2003 with SQL server standard edition is
> there any point putting more than 2Gb of ram in the machine ?
> i.e i base this on 2Gb being the max for Sql server 200.
> thanks for your advice
> Scott
>
Yes.
Don't forget about the O/S and any other stuff that is going on. Put at
least 3GB in the box. 1 for the O/S and 2 for SQL. ;-)
Rick Sawtell
MCT, MCSD, MCDBA
|||brilliant. many thanks
scott

any point in putting more than 2Gb ram in machine for standard edition ?

if a member server runs 2000 or 2003 with SQL server standard edition is
there any point putting more than 2Gb of ram in the machine ?
i.e i base this on 2Gb being the max for Sql server 200.
thanks for your advice
ScottStandard edition is limited to 2GB so the additional memory won't be used by
SQL Server directly. However, the OS requires memory too so you should
consider this as well as memory needed by other apps. I usually spec 3GB
for a dedicated SQL Server 2000 running Standard Edition.
Hope this helps.
Dan Guzman
SQL Server MVP
"scott" <aintnoapmhere@.yahoo.com> wrote in message
news:%23T2POP72FHA.632@.TK2MSFTNGP10.phx.gbl...
> if a member server runs 2000 or 2003 with SQL server standard edition is
> there any point putting more than 2Gb of ram in the machine ?
> i.e i base this on 2Gb being the max for Sql server 200.
> thanks for your advice
> Scott
>|||"scott" <aintnoapmhere@.yahoo.com> wrote in message
news:%23T2POP72FHA.632@.TK2MSFTNGP10.phx.gbl...
> if a member server runs 2000 or 2003 with SQL server standard edition is
> there any point putting more than 2Gb of ram in the machine ?
> i.e i base this on 2Gb being the max for Sql server 200.
> thanks for your advice
> Scott
>
Yes.
Don't forget about the O/S and any other stuff that is going on. Put at
least 3GB in the box. 1 for the O/S and 2 for SQL. ;-)
Rick Sawtell
MCT, MCSD, MCDBA|||brilliant. many thanks
scott

any point in putting more than 2Gb ram in machine for standard edition ?

if a member server runs 2000 or 2003 with SQL server standard edition is
there any point putting more than 2Gb of ram in the machine ?
i.e i base this on 2Gb being the max for Sql server 200.
thanks for your advice
ScottStandard edition is limited to 2GB so the additional memory won't be used by
SQL Server directly. However, the OS requires memory too so you should
consider this as well as memory needed by other apps. I usually spec 3GB
for a dedicated SQL Server 2000 running Standard Edition.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"scott" <aintnoapmhere@.yahoo.com> wrote in message
news:%23T2POP72FHA.632@.TK2MSFTNGP10.phx.gbl...
> if a member server runs 2000 or 2003 with SQL server standard edition is
> there any point putting more than 2Gb of ram in the machine ?
> i.e i base this on 2Gb being the max for Sql server 200.
> thanks for your advice
> Scott
>|||"scott" <aintnoapmhere@.yahoo.com> wrote in message
news:%23T2POP72FHA.632@.TK2MSFTNGP10.phx.gbl...
> if a member server runs 2000 or 2003 with SQL server standard edition is
> there any point putting more than 2Gb of ram in the machine ?
> i.e i base this on 2Gb being the max for Sql server 200.
> thanks for your advice
> Scott
>
Yes.
Don't forget about the O/S and any other stuff that is going on. Put at
least 3GB in the box. 1 for the O/S and 2 for SQL. ;-)
Rick Sawtell
MCT, MCSD, MCDBA|||brilliant. many thanks
scott