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 |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2010-08-23 : 18:29:40
|
| When I tried to Simple delete a database is taking longer time, simultaneously when this database along with other datbases from the Instance were disturbed in the transaction logs, as well.I have changed the options of the database to Restricted Mode and still doing the same and jeopardising the Transaction log chain during this deletion time.This database has got no other connections apart from the Maintenance plan driven Transaction Logs being taken for every quarter-an-hour.How to delete forcibly?Can anyone let me know what should be the consequence and how best I can delete this database. Thanks All. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-08-23 : 19:22:48
|
| Do you know whatALTER DATABASEis??Do you know what Books Online is?Do you know what you are doing?Are you dangerous?"Yes Ice...man...I am Dangerous"I don't care what anyone says..I still love Cruise in a movie...what being a Jersey Boy...and Living in the town next door, and dating my Wifes Friend in high school...But I'm not Prejudice...I got top gun in my top 10Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-08-23 : 19:47:23
|
Thanks Tkizer.Meanwhile I have got it right. It's like sitting on the same branch and trying to cut the branch  . Instead I have used the Master database from there it got deleted.For your clarification: Jeopardising the transaction logs --> This database which is also generating the 15-minutes transaction log backup and runs under the maintenance plan. While I previously deleting is not accepting the deletion at the same time the transaction logs during that particular juncture didn't happen.Now all is ok.Thanks for the concerned answer. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-08-24 : 00:31:35
|
| The point is made clear to TKIZER,If so, it worked for me and for others it may be unwanted question. |
|
|
|
|
|
|
DB Delete