sql server dts: Hi,
I created a blank databse andctarted copying over tables from an existing
database. I forgot to limit the transaction log file so it grew so big (10
GB). when I realized it, i turned on the autoshrink. after that, i cannot
even see the databases in the enterprises manager anymore. it freezes
everytime i tried to open them. i tried to backup log, but it said another
process was running. so i assumed the autoshrink was running. i tried to turn
off the autoshrink using sp_dboption but the query ran for 14 hours and
didn't give me anything. i tried to detach the database but it said the
databse is in use. what should i do now? i want to delete the new database
and start from beginning. another question: i have 1 old database and 1 live
database. i want to update tables in the old db with the live data but when i
imported them it gave error message saying 'duplicate'. how do i skip the
duplicate data when i import the live data?
thanks in advance,

There may be something locks database.

If any query is creating blocking kill it

I you do not require other spid on that DB kill them also.

now run

alter database test set read_only with rollback immediate

It will prevent other users to changing data in the DB.

Now drop the database

In importing data you are getting duplicate due to primary or unique key
constraints

copy the data to temp table and use it to insert and update data in
destination table.



Regards
Amish shah