truncate the log file of a Microsoft SQL database
With SQL 2000 always ran into the problem of the automatic log file size of the database, it defaults to the LDF file grows in size continuously until it reaches the maximum size set in the database, or worse, up to end of disk space.
This situation is created simply because the LDF file keeps track of all transactions, even when properly committed.
To resolve this problem, simply run the command: DBCC
BACKUP LOG [database name] WITH TRUNCATE_ONLY
simple, immediate, and above all, decisive.
via: merlinox.tumblr.com
Thursday, July 31, 2008
Thursday, July 17, 2008
What Is The White Mucus In My Urine
Quick Restart services
developing batch applications that perform tasks in a Microsoft environment, one is invariably working with windows services.
With this type of programs the way they work is slightly different, and so no longer able to launch applications with the development environment, it is more often confronted with the awkward interface for managing services.
Well, well the end is not uncomfortable, but working with and debugging these applications there is a stop and start hundreds of times a day.
order to stop and then start the services with a single click, you can easily create a. Bat with these 3 lines of code:
NET STOP "service name"
pause net start "service name"
The pause between the two commands is essential, because operationally it will launch this command, the service is stopped as soon as you can compile the executable, and a completed build with a single shipment in the DOS window open, you can restart the service.
Comfortable, convenient and quick ...
developing batch applications that perform tasks in a Microsoft environment, one is invariably working with windows services.
With this type of programs the way they work is slightly different, and so no longer able to launch applications with the development environment, it is more often confronted with the awkward interface for managing services.
Well, well the end is not uncomfortable, but working with and debugging these applications there is a stop and start hundreds of times a day.
order to stop and then start the services with a single click, you can easily create a. Bat with these 3 lines of code:
NET STOP "service name"
pause net start "service name"
The pause between the two commands is essential, because operationally it will launch this command, the service is stopped as soon as you can compile the executable, and a completed build with a single shipment in the DOS window open, you can restart the service.
Comfortable, convenient and quick ...
Subscribe to:
Posts (Atom)