Can I give specify size for errorlog files?

Hi,
Can someone tell how can I give specifically size of errorlog files those
are generate from SQL Server 2000 self? And also I want to know if I can
change the archived errorlog files number from 6 to 10?
Regards,
-Chen
You can change the number of logs using Enterprise Manager by right clicking
on SQL Server Logs and choosing configure. Here you can change the default
of 6 to a higher number. As to the size, you could set up a job to monitor
the size of the current log and call sp_cycle_errorlog if it gets too big. I
don't know of a way to set the max size explicitly.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:36FD6FCB-557E-47B7-B983-2DBC38B423E0@.microsoft.com...
> Hi,
> Can someone tell how can I give specifically size of errorlog files those
> are generate from SQL Server 2000 self? And also I want to know if I can
> change the archived errorlog files number from 6 to 10?
> Regards,
> -Chen
>
|||Hi Chen,
As mentioned by Jasper, you can use sp_cycle_errorlog on a frequent basis to
limit the size of the error logs. This way you don't have to worry much about
the size of the file.
At our firm, we run it on a weekly basis.
Thanks
Yogish
|||Thanks Jasper and Yogish input info. It's really helped.
-Chen
"Yogish" wrote:

> Hi Chen,
> As mentioned by Jasper, you can use sp_cycle_errorlog on a frequent basis to
> limit the size of the error logs. This way you don't have to worry much about
> the size of the file.
> At our firm, we run it on a weekly basis.
> --
> Thanks
> Yogish

Can I give specify size for errorlog files?

Hi,
Can someone tell how can I give specifically size of errorlog files those
are generate from SQL Server 2000 self? And also I want to know if I can
change the archived errorlog files number from 6 to 10?
Regards,
-ChenYou can change the number of logs using Enterprise Manager by right clicking
on SQL Server Logs and choosing configure. Here you can change the default
of 6 to a higher number. As to the size, you could set up a job to monitor
the size of the current log and call sp_cycle_errorlog if it gets too big. I
don't know of a way to set the max size explicitly.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:36FD6FCB-557E-47B7-B983-2DBC38B423E0@.microsoft.com...
> Hi,
> Can someone tell how can I give specifically size of errorlog files those
> are generate from SQL Server 2000 self? And also I want to know if I can
> change the archived errorlog files number from 6 to 10?
> Regards,
> -Chen
>|||Hi Chen,
As mentioned by Jasper, you can use sp_cycle_errorlog on a frequent basis to
limit the size of the error logs. This way you don't have to worry much abou
t
the size of the file.
At our firm, we run it on a weekly basis.
Thanks
Yogish|||Thanks Jasper and Yogish input info. It's really helped.
-Chen
"Yogish" wrote:

> Hi Chen,
> As mentioned by Jasper, you can use sp_cycle_errorlog on a frequent basis
to
> limit the size of the error logs. This way you don't have to worry much ab
out
> the size of the file.
> At our firm, we run it on a weekly basis.
> --
> Thanks
> Yogish

Can I give specify size for errorlog files?

Hi,
Can someone tell how can I give specifically size of errorlog files those
are generate from SQL Server 2000 self? And also I want to know if I can
change the archived errorlog files number from 6 to 10?
Regards,
-ChenYou can change the number of logs using Enterprise Manager by right clicking
on SQL Server Logs and choosing configure. Here you can change the default
of 6 to a higher number. As to the size, you could set up a job to monitor
the size of the current log and call sp_cycle_errorlog if it gets too big. I
don't know of a way to set the max size explicitly.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:36FD6FCB-557E-47B7-B983-2DBC38B423E0@.microsoft.com...
> Hi,
> Can someone tell how can I give specifically size of errorlog files those
> are generate from SQL Server 2000 self? And also I want to know if I can
> change the archived errorlog files number from 6 to 10?
> Regards,
> -Chen
>|||Hi Chen,
As mentioned by Jasper, you can use sp_cycle_errorlog on a frequent basis to
limit the size of the error logs. This way you don't have to worry much about
the size of the file.
At our firm, we run it on a weekly basis.
--
Thanks
Yogish|||Thanks Jasper and Yogish input info. It's really helped.
-Chen
"Yogish" wrote:
> Hi Chen,
> As mentioned by Jasper, you can use sp_cycle_errorlog on a frequent basis to
> limit the size of the error logs. This way you don't have to worry much about
> the size of the file.
> At our firm, we run it on a weekly basis.
> --
> Thanks
> Yogishsql

can i calculate a database backup size?

Hi,
I've a database with multiple millions of rows in a small set of tables.
Most of this data is historical, so I want to split the data in multiple
databases, make backups of about 600 MB each and burn this to cd roms. I
want to split the data based on dates stored inside the tables. Is there a
way to calculate the amount of bytes inside a database backup file that will
be produced ba a diven select statement when it uses all rows of a table?
SvenBackups aren't caused by select statements. They backup all of the physical
data in the database unless you do file or filegroup backups. So if you
want to get an idea of the size the backup will be you only have to look at
how much actual data (not including free space) there is in the db and it
will be approximately that. You can compress backups quite easily with
WINZIP or similar utilities and fit much more on a cd.
--
Andrew J. Kelly
SQL Server MVP
"Sven Erik Matzen" <sven.matzen@.dontspamme.com> wrote in message
news:eJ3BY7XZDHA.1832@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I've a database with multiple millions of rows in a small set of tables.
> Most of this data is historical, so I want to split the data in multiple
> databases, make backups of about 600 MB each and burn this to cd roms. I
> want to split the data based on dates stored inside the tables. Is there a
> way to calculate the amount of bytes inside a database backup file that
will
> be produced ba a diven select statement when it uses all rows of a table?
> Sven
>|||Good point Dan. Be sure to run UPDATE USAGE or use the Updateusage option
when running it.
--
Andrew J. Kelly
SQL Server MVP
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:%23Cs0mbZZDHA.2572@.TK2MSFTNGP12.phx.gbl...
> To add to Andrew's response, the reserved space reported by sp_spaceused
> can provide a rough estimate of database backup space requirements.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> --
> SQL FAQ links (courtesy Neil Pike):
> http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> http://www.sqlserverfaq.com
> http://www.mssqlserver.com/faq
> --
> "Sven Erik Matzen" <sven.matzen@.dontspamme.com> wrote in message
> news:eJ3BY7XZDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I've a database with multiple millions of rows in a small set of
> tables.
> > Most of this data is historical, so I want to split the data in
> multiple
> > databases, make backups of about 600 MB each and burn this to cd roms.
> I
> > want to split the data based on dates stored inside the tables. Is
> there a
> > way to calculate the amount of bytes inside a database backup file
> that will
> > be produced ba a diven select statement when it uses all rows of a
> table?
> >
> > Sven
> >
> >
>|||Sven,
That's a really awkward way of going about it. Why not just BCP out the
data to flat files (I suggest native mode) and load them onto the CD(s).
You can use normal select statements to break them up into what ever you
want. It will be much cleaner and easier than attempting to do this with
backups. As for the size, it would be difficult to tell exactly unless all
your columns are of the fixed size (no varchars, text etc.). I think with a
few test selects you should be able to get a pretty good idea though.
--
Andrew J. Kelly
SQL Server MVP
"Sven Erik Matzen" <sven.matzen@.dontspamme.com> wrote in message
news:u9WCdCkZDHA.2520@.TK2MSFTNGP09.phx.gbl...
> I plan to split up database. 99% of the size of my database is caused by
> "Table1". What I need to know is: How many rows do I have to delete to be
> able to produce a backup os ~600MByte. I need functional database backups
to
> be able to restore data from a specific date.
> The idea was to have a second database with all the data but Table1, then
> - do a move of x rows from the original database to the new database
> - then make a backup
> - truncate Table1 of the backed up database
> - repeat these steps until all data is backed up.
> Now I need to know what type of relationship is there between space used
in
> a database and space used in a backup file. I don't want to split one huge
> database backup file to burn it on cdroms, because then I need to restore
> the complete database from 100 CDs just to lookup one row - that's not
what
> I had in mind ;).
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eQAY7jYZDHA.3444@.tk2msftngp13.phx.gbl...
> > Backups aren't caused by select statements. They backup all of the
> physical
> > data in the database unless you do file or filegroup backups. So if you
> > want to get an idea of the size the backup will be you only have to look
> at
> > how much actual data (not including free space) there is in the db and
it
> > will be approximately that. You can compress backups quite easily with
> > WINZIP or similar utilities and fit much more on a cd.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Sven Erik Matzen" <sven.matzen@.dontspamme.com> wrote in message
> > news:eJ3BY7XZDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > > Hi,
> > >
> > > I've a database with multiple millions of rows in a small set of
tables.
> > > Most of this data is historical, so I want to split the data in
multiple
> > > databases, make backups of about 600 MB each and burn this to cd roms.
I
> > > want to split the data based on dates stored inside the tables. Is
there
> a
> > > way to calculate the amount of bytes inside a database backup file
that
> > will
> > > be produced ba a diven select statement when it uses all rows of a
> table?
> > >
> > > Sven
> > >
> > >
> >
> >
>

Can anyone tell me.

Let's assume I have to go for setup of sql server and I have a 20 GB
database and daily transaction is around 200 KB size. Can any one tell me
what I have to do for setup sql server like what are the configuration and
what are the step I have to consider.
Thanks
John
For the most parts, SQL Server is smart enough to figure out the appropriate
configuration during installation. However, there are things to consider
before you install (hardware requirements, disk layout, etc...) and things
to do after you're done (maintenance).
Suggest you check out http://www.microsoft.com/sql/ and review some of the
installation and management papers then come back here with specific
questions.
joe.
"John" <naissani@.hotmail.com> wrote in message
news:Olt0u6cFFHA.1348@.TK2MSFTNGP14.phx.gbl...
> Let's assume I have to go for setup of sql server and I have a 20 GB
> database and daily transaction is around 200 KB size. Can any one tell me
> what I have to do for setup sql server like what are the configuration and
> what are the step I have to consider.
> Thanks
> John
>