Dual trans logs

Hello,
I have a server with two active transaction logs on 1
database and need to remove one, the problem arises when
I try to. Anyone advise on a procedure to do this?
Thank you in advance,
Tom
tww@.ccsiservices.comExactly how are you attempting this and what is the actual error?
--
Andrew J. Kelly
SQL Server MVP
"Tom" <anonymous@.discussions.microsoft.com> wrote in message
news:009201c3a560$32807a30$a501280a@.phx.gbl...
> Hello,
> I have a server with two active transaction logs on 1
> database and need to remove one, the problem arises when
> I try to. Anyone advise on a procedure to do this?
> Thank you in advance,
> Tom
> tww@.ccsiservices.com|||Well I have not tried yet, though I spoke with someone
who was trying. I am off-site and will be going into the
office tomorrow to take a look. They opened database
properties in the Enterprise Manager and tried to just
delete the extra log file (which we are still trying to
figure out why it was put there) but it says something
about the file has to be empty to remove it..etc. If the
actual error is needed I can get it later today. I was
online and decided to post this query to see if anyone
had experience with this.
on a side note, the system is not secured and this extra
log file setting was setup on Wednesday this week, during
maintenance it was noticed. I have been out of the office
so I am still getting all the facts.
Thank you,
Tom
>--Original Message--
>Exactly how are you attempting this and what is the
actual error?
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Tom" <anonymous@.discussions.microsoft.com> wrote in
message
>news:009201c3a560$32807a30$a501280a@.phx.gbl...
>> Hello,
>> I have a server with two active transaction logs on 1
>> database and need to remove one, the problem arises
when
>> I try to. Anyone advise on a procedure to do this?
>> Thank you in advance,
>> Tom
>> tww@.ccsiservices.com
>
>.
>|||OK that's more to go on. Take a look at DBCC SHRINKFILE and pay attention
to the EMPTYFILE option in BooksOnLine. You need to move any data to the
other file and it gets marked so as it doesn't fill again. Then you can use
ALTER DATABASE to drop the file.
--
Andrew J. Kelly
SQL Server MVP
"Tom" <anonymous@.discussions.microsoft.com> wrote in message
news:01dd01c3a572$1a280130$a601280a@.phx.gbl...
> Well I have not tried yet, though I spoke with someone
> who was trying. I am off-site and will be going into the
> office tomorrow to take a look. They opened database
> properties in the Enterprise Manager and tried to just
> delete the extra log file (which we are still trying to
> figure out why it was put there) but it says something
> about the file has to be empty to remove it..etc. If the
> actual error is needed I can get it later today. I was
> online and decided to post this query to see if anyone
> had experience with this.
> on a side note, the system is not secured and this extra
> log file setting was setup on Wednesday this week, during
> maintenance it was noticed. I have been out of the office
> so I am still getting all the facts.
> Thank you,
> Tom
> >--Original Message--
> >Exactly how are you attempting this and what is the
> actual error?
> >
> >--
> >
> >Andrew J. Kelly
> >SQL Server MVP
> >
> >
> >"Tom" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:009201c3a560$32807a30$a501280a@.phx.gbl...
> >> Hello,
> >>
> >> I have a server with two active transaction logs on 1
> >> database and need to remove one, the problem arises
> when
> >> I try to. Anyone advise on a procedure to do this?
> >>
> >> Thank you in advance,
> >> Tom
> >> tww@.ccsiservices.com
> >
> >
> >.
> >|||Great! Thanks a ton, That will save some time.
Have a great weekend.
Tom
>--Original Message--
>OK that's more to go on. Take a look at DBCC SHRINKFILE
and pay attention
>to the EMPTYFILE option in BooksOnLine. You need to
move any data to the
>other file and it gets marked so as it doesn't fill
again. Then you can use
>ALTER DATABASE to drop the file.
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Tom" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01dd01c3a572$1a280130$a601280a@.phx.gbl...
>> Well I have not tried yet, though I spoke with someone
>> who was trying. I am off-site and will be going into
the
>> office tomorrow to take a look. They opened database
>> properties in the Enterprise Manager and tried to just
>> delete the extra log file (which we are still trying to
>> figure out why it was put there) but it says something
>> about the file has to be empty to remove it..etc. If
the
>> actual error is needed I can get it later today. I was
>> online and decided to post this query to see if anyone
>> had experience with this.
>> on a side note, the system is not secured and this
extra
>> log file setting was setup on Wednesday this week,
during
>> maintenance it was noticed. I have been out of the
office
>> so I am still getting all the facts.
>> Thank you,
>> Tom
>> >--Original Message--
>> >Exactly how are you attempting this and what is the
>> actual error?
>> >
>> >--
>> >
>> >Andrew J. Kelly
>> >SQL Server MVP
>> >
>> >
>> >"Tom" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:009201c3a560$32807a30$a501280a@.phx.gbl...
>> >> Hello,
>> >>
>> >> I have a server with two active transaction logs on
1
>> >> database and need to remove one, the problem arises
>> when
>> >> I try to. Anyone advise on a procedure to do this?
>> >>
>> >> Thank you in advance,
>> >> Tom
>> >> tww@.ccsiservices.com
>> >
>> >
>> >.
>> >
>
>.
>