Archive SQL Server Logs..?

Hi Folks
is anyone knows that how can i archive(delete) log file for current date or
specific date'?
Thanx in advance
regards
--
Message posted via http://www.sqlmonster.comHi,
Did you mean SQL Server error logs or Tranasction log backups?
If it is Error log, sql server by itself keep only 6+1 (current) copies by
default. The old files will be deleted automatically.
If it is Transaction log backup files, then use database maintenance plan to
fix a archival day. So as old file(s) will be deleted automatically.
Thanks
Hari
SQL Server MVP
"sonny singh via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:fa2cf9e684d741419c1094db51a9fea5@.SQLMonster.com...
> Hi Folks
> is anyone knows that how can i archive(delete) log file for current date
> or
> specific date'?
> Thanx in advance
> regards
> --
> Message posted via http://www.sqlmonster.com|||Hi Hari
You can change the number of error logs maintained by editing the Registry
for any instance. For the default instance, find the key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer and edit it by
adding a new value. Define the value with the name NumErrorLogs, and the
type REG_DWORD. Supply any initial value desired, but keep in mind that the
value you enter when editing the Registry will be in hexadecimal format.
For a named instance, you need to find the key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<SQL Server
Instance Name>\MSSQLServer. Again, use the Edit feature of the Registry to
add a new value with the name NumErrorLogs of type REG_DWORD, and supply an
initial value in hexadecimal format.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:Os1pMt2bFHA.3712@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Did you mean SQL Server error logs or Tranasction log backups?
> If it is Error log, sql server by itself keep only 6+1 (current) copies by
> default. The old files will be deleted automatically.
> If it is Transaction log backup files, then use database maintenance plan
> to fix a archival day. So as old file(s) will be deleted automatically.
> Thanks
> Hari
> SQL Server MVP
> "sonny singh via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
> message news:fa2cf9e684d741419c1094db51a9fea5@.SQLMonster.com...
>> Hi Folks
>> is anyone knows that how can i archive(delete) log file for current date
>> or
>> specific date'?
>> Thanx in advance
>> regards
>> --
>> Message posted via http://www.sqlmonster.com
>

Apply PreSP4 fix

Hi,
I need to apply 3 preSP4 fix to SQL server.
Can i aplly all 3 fix and if so, is the order of how i apply them important?
Kind Regards
Michael TroelsenService packs are cumulative... That means you simply install the most
recent service pack and you will be up-to-date... When you download a
service pack, there will always be a readme file, and installation
procedures...
ALWAYS, read the files and follow the instructions... However generally
installing service packs is very easy... Simply calling a bat file...
"Michael Troelsen" <mit@.edbgruppen.dk> wrote in message
news:Ok7vagv6DHA.1804@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I need to apply 3 preSP4 fix to SQL server.
> Can i aplly all 3 fix and if so, is the order of how i apply them
important?
> Kind Regards
> Michael Troelsen
>
>|||Unless the documentation for these fixes specifically mentions being
installed in a certain order you should be safe installing in any order.
Mike Kruchten
"Michael Troelsen" <mit@.edbgruppen.dk> wrote in message
news:Ok7vagv6DHA.1804@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I need to apply 3 preSP4 fix to SQL server.
> Can i aplly all 3 fix and if so, is the order of how i apply them
important?
> Kind Regards
> Michael Troelsen
>
>|||Michael - in normal circumstances you would only install the latest one, but
the answer is to check with whoever gave you the fixes.#
> I need to apply 3 preSP4 fix to SQL server.
> Can i aplly all 3 fix and if so, is the order of how i apply them important?
> Kind Regards
> Michael Troelsen
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq|||I came to the same conclusion when i started to check the file version.
Thanx
"Neil Pike" <neilpike@.compuserve.com> wrote in message
news:VA.000061bc.001144a7@.compuserve.com...
> Michael - in normal circumstances you would only install the latest one,
but
> the answer is to check with whoever gave you the fixes.#
> > I need to apply 3 preSP4 fix to SQL server.
> > Can i aplly all 3 fix and if so, is the order of how i apply them
important?
> >
> > Kind Regards
> > Michael Troelsen
> >
> Neil Pike MVP/MCSE. Protech Computing Ltd
> Reply here - no email
> SQL FAQ (484 entries) see
> http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
> (faqxxx.zip in lib 7)
> or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> or www.sqlserverfaq.com
> or www.mssqlserver.com/faq
>

Append Data

Hi,
Appreciated it if someone could help me with regards to
the abovesaid problem.
I don't know how to append data using SQL Query Analyzer
from table a to table b because it will create duplicate
table b.recordnumber(auto number) in table b. I tried to
use DTS but failed due to the duplicate record number(auto
number).
tq.
Hi,
Use "SET IDENTITY_INSERT" to allow explicit values in acolumn with identity.
See SET IDENTITY_INSERT in books online. There is good example as well which
shows the usage.
Sample:-
create table id1(i int identity, k char(10))
create table id2(i int identity, k char(10))
go
insert into id1(K) values('hari')
insert into id2(K) values('raj')
go
select * from id1
select * from id2
go
set identity_insert id1 on
insert into id2(k) select k from id1
go
select * from id2
Thanks
Hari
MCDBA
"GW" <anonymous@.discussions.microsoft.com> wrote in message
news:657801c4753d$a64178e0$a501280a@.phx.gbl...
> Hi,
> Appreciated it if someone could help me with regards to
> the abovesaid problem.
> I don't know how to append data using SQL Query Analyzer
> from table a to table b because it will create duplicate
> table b.recordnumber(auto number) in table b. I tried to
> use DTS but failed due to the duplicate record number(auto
> number).
> tq.