Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-10 : 09:45:10
|
| lie21073 writes "Hi,I created a blank databse and started 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" |
|
|
|
|
|
Autoshrink error?