SQLDBAgeeks
Contact Us
Home
Contact
Services
Tuesday, August 31, 2010
Transaction logs growing out of control?
login to SSMS and click new query :
backup log adventureworks with truncate_only
next, right click database adventureworks>tasks> shrink> files>file type > logs> click ok
thats it --only ms SQL server 2005
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment