Truncate Table

Technical Article

RE: log file too big

  • Reply

If the users can be stopped for 10 minutes, One simple solution is, detatch db and attach it back with only the .mdf file. .ldf will be created with default size of Model and you can set the max growth. This will resolve the problem Regards Fred

You rated this post out of 5. Change rating

2003-06-10

1 reads

Technical Article

RE: How to keep and restore the deleted records?

  • Reply

quote: sorry for asking this, but how can your records be deleted by accident BOFH Seriously though, you always find users who contact you and say "Oh, I deleted the main list of companies, can you retrieve it for me?" You ask why they deleted it and the reply is often "I wanted to see […]

You rated this post out of 5. Change rating

2003-05-25

Technical Article

RE: Failover Clustering

  • Reply

Some of the limitations of Win 2K clustering should be being overcome in Win 2003. Check out http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/windowsserver2003/technologies/clustering/default.asp for details. They seem to have taken a leaf out of Veritas's book and eliminated the Quorum drive, making N plus I (how do I put in a plus char in this utility - it seems to […]

You rated this post out of 5. Change rating

2003-05-22

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers