Error 5020 after try to delete one of log files

Platform: SQL Server 2k with sp2
OS: W2k sp2
I tried to move log files at one database from location A
to another location B. I first created new log fileB.ldf
for this database at locationB. Then shrank the original
log fileA.ldf as much as possible. Next I tried to
delete fileA from SQL Server EM -> properties ->
transaction log-> highligt fileA.ldf -> delete. But I got
error 5020: The primary data or log file cannot be removed
from a database.
How can I drop or move log files from database?
Thanks.Maggie,
First, detach the database using sp_detach_db after making sure that users
are not accessing it.Once done, the database is thus offline.Now copy the
.ldf file to location B.Attach the database using sp_attach_db, mentioning
the new location for .ldf.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Maggie" <seamorning@.yahoo.com> wrote in message
news:5d4901c35781$4df49c60$a001280a@.phx.gbl...
> Platform: SQL Server 2k with sp2
> OS: W2k sp2
> I tried to move log files at one database from location A
> to another location B. I first created new log fileB.ldf
> for this database at locationB. Then shrank the original
> log fileA.ldf as much as possible. Next I tried to
> delete fileA from SQL Server EM -> properties ->
> transaction log-> highligt fileA.ldf -> delete. But I got
> error 5020: The primary data or log file cannot be removed
> from a database.
> How can I drop or move log files from database?
> Thanks.|||Go to EM, right click the database, then Transaction Log tab, select the 2nd
log file, press Delete button.
You can't delete first log file, but other log files you can delete.
"Maggie" <seamorning@.yahoo.com> wrote in message
news:5e5d01c3578e$5cd34cb0$a001280a@.phx.gbl...
> How can just delete the extra log files from one
> location? I only want to keep one?
> >--Original Message--
> >Maggie,
> >
> >First, detach the database using sp_detach_db after
> making sure that users
> >are not accessing it.Once done, the database is thus
> offline.Now copy the
> >..ldf file to location B.Attach the database using
> sp_attach_db, mentioning
> >the new location for .ldf.
> >
> >--
> >Dinesh.
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Maggie" <seamorning@.yahoo.com> wrote in message
> >news:5d4901c35781$4df49c60$a001280a@.phx.gbl...
> >> Platform: SQL Server 2k with sp2
> >> OS: W2k sp2
> >> I tried to move log files at one database from location
> A
> >> to another location B. I first created new log
> fileB.ldf
> >> for this database at locationB. Then shrank the
> original
> >> log fileA.ldf as much as possible. Next I tried to
> >> delete fileA from SQL Server EM -> properties ->
> >> transaction log-> highligt fileA.ldf -> delete. But I
> got
> >> error 5020: The primary data or log file cannot be
> removed
> >> from a database.
> >>
> >> How can I drop or move log files from database?
> >>
> >> Thanks.
> >
> >
> >.
> >

Error 3624 Location: fakerowset.cpp:251

Hello,
I have the following error when I want to access the design
mode in Entreprise Manager of some tables :
Microsoft SQL-DMO (ODBC SQLState: HY000)
Error: 3624
Expression: accCategory == ACC_CATEGORY_NORMAL || accCatgegory ==
ACC_CATEGORY_BIT
SOPID: 52
Process ID : 2876
I'm running SQL server 2000 with SP3a.
Thanks for your help
You seem to be running into some sort of ASSERT is what I think. Please run
checkdb on your database, and check on the SQL error logs for any stack
dumps. Please paste the input buffer and short stack dump in this thread
and we can analyse.
Also if corruption is the cause, you also want to get your hw vendors
thoroughly involved and have them check your disk, controllers, etc.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error 3624 Location: fakerowset.cpp:251

Hello,
I have the following error when I want to access the design
mode in Entreprise Manager of some tables :
Microsoft SQL-DMO (ODBC SQLState: HY000)
Error: 3624
Expression: accCategory == ACC_CATEGORY_NORMAL || accCatgegory == ACC_CATEGORY_BIT
SOPID: 52
Process ID : 2876
I'm running SQL server 2000 with SP3a.
Thanks for your helpYou seem to be running into some sort of ASSERT is what I think. Please run
checkdb on your database, and check on the SQL error logs for any stack
dumps. Please paste the input buffer and short stack dump in this thread
and we can analyse.
Also if corruption is the cause, you also want to get your hw vendors
thoroughly involved and have them check your disk, controllers, etc.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

error 3520 on sql insert statement from a text file (only happens in 1 location)

I have a program that uses the Microsoft ODBC text driver Driver={Microsoft Text Driver (*.txt; *.csv)} this is used to make a connection to the database and then execute an sql insert to insert data from a flat file into an access database. The code works at hundreds of locations but for some reason it does not work at 1. I have ran an sql trace and found the error 3520 which would mean the data in the text file does not match the table that it is being inserted into but I have checked that and have tried using the same data on my computer and it works fine. I have also ran mdac compenent checker and there are no mismatched files. Any ideas on how to correct this or if anyone else has ever even seen this please help...Moving thread to Data Access Forum.