by Vitaly Zayko
10. April 2009 15:26
You know that LOG files of actively used SQL Server databases could become huge, even bigger than data (MDF) file.
In SQL2005 you can use this script to shrink LOG file size:
USE <database name>
BACKUP LOG <database name> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<log file name>, <preferred size>)
But this is no longer working in SQL2008. So do this:
USE <database name>
ALTER DATABASE <database name> SET RECOVERY SIMPLE
DBCC SHRINKFILE(<log file name>, <preferred size>)
ALTER DATABASE <database name> SET RECOVERY FULL
Good luck!
adeeb637-cb51-41e1-ad91-9094b7fc990d|0|.0
Tags: sql
SQL
by Vitaly Zayko
24. October 2008 10:20
If you are developing database driven Applications, then you definitely need to add this resource to your Internet Favorites:
http://www.connectionstrings.com
This is the most complete resource I ever seen that contains connection strings to probably any database system around.
Great job! Thank you, guys!
d7664f10-51b2-4b66-bc3c-6942ec123a21|0|.0
Tags: sql
General