Truncate log on MS Sql 2005

When the transaztion log is full, you can truncate it by using this query:

 

USE DatabaseName

GO

DBCC SHRINKFILE(<TransactionLogName>, 1)

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(<TransactionLogName>, 1)

GO

 

<TransactionLogName> is the name of the t log without extension and path

 

_____________________________________

Stefano Mazgon

 

Commenti

Posta un commento

Post popolari in questo blog

Errors in attaching mdf after ldf corruption or deletion

Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted. This errors happens when corrupt database log are attempted to attach to new server. Solution of this error is little long and it involves restart of the server. I recommend following all the steps below in order without skipping any of them. Fix/Solution/Workaround: SQL Server logs are corrupted and they need to be rebuilt to make the database operational. Follow all the steps in order. Replace the yourdatabasename name with real name of your database. 1. Create a new database with same name which you are trying to recover or restore. (In our error message it is yourdatabasename ). Make sure the name of the MDF file (primary data file) and LDF files (Log files) same as previous database data and log file. 2. Stop SQL Server. Move original MDF file from older server (or location) to new server (or location) by replacing just created MDF file. Del...
Continua a leggere

Acer Aspire ONE AOA150 won't boot, display black, only power led on

Just need to reinstall the  bios  and everything will be fine. check this site:  http://sites.google.com/site/maclesblogspotcom/BIOS   First format an USB stick with FAT.  Download the latest BIOS, and put both FLASHIT.EXE and the BIOS file in the root directory of the stick. Rename the BIOS file to ZG5IA32.FD, that's important. Do not remove the USB stick.  Turn the AA1 off, make sure both battery and AC adapter are connected. Press Fn+Esc, keep it pressed and press the power button to turn the AA1 on. Release Fn+Esc after a few seconds, the power button will be blinking. Press the power button once. The AA1 will now initiate the BIOS flash, do not interrupt it under any circumstances. After a while the power button will stop blinking, and the AA1 will reboot shortly after. Wait patiently.  The BIOS has been flashed and all settings reset to default.  If for some reason you made a mistake during the procedure and it doesn't reboot by itself wait ...
Continua a leggere

Remove hidden partitions from a disk

To remove all partitions from a disk from Windows 7 shell (like Mac OS EFI System partition):      1. On the command prompt type diskpart and answer to any possible UAC prompt.    2. On the new diskpart prompt, type list disk. Note the Disk ### column.    3. Type, select disk ### (with ### being the partition you wish to delete. Usually partition 0 and wth those 200 MB of size)    4. Finish by typing, clean.   _____________________________________ Stefano Mazgon  
Continua a leggere