A list of those random things you find really useful when fixing IT issues. It takes ages to track them down again later, and you KNOW you'll come across the issue again. So here they are for me...and YOU...to refer back to any time.
Showing posts with label database. Show all posts
Showing posts with label database. Show all posts
17 January 2014
19 February 2013
Successfully Shrink Database Log File (*.ldf) in SQL 2005
This may also work in other versions of SQL, but I've not tested it.
First, back the database up. I'm assuming you can figure out the details of backing up. I normally backup to disk and create a new file for the backup in a set backup location/drive/disk.
Then, set the database to use simple backup mode, as seen in the drop-down list in the image below.
First, back the database up. I'm assuming you can figure out the details of backing up. I normally backup to disk and create a new file for the backup in a set backup location/drive/disk.
Then, set the database to use simple backup mode, as seen in the drop-down list in the image below.
Finally, shrink the database, ensuring you select the Reorganize files... option. Select a minimum freespace of anywhere from 0 to 20. If it is low, you are likely to see some instant growth in your database. If it is too high, you're wasting space.
Labels:
database,
ldf,
log file,
shrink database,
simple backup,
SQL,
SQL server
08 January 2013
Symantec Endpoint Protection Manager 11 - Unable to Communicate with Reporting Component
- If you are on a 32-bit OS, skip the next step.
- If you are on a 64-bit OS, first go to 32-bit ODBC Control Panel. To do this do the following:
Go to %systemroot%\Windows\SysWoW64 folder (Example - Click Start -> Run -> C:\Windows\Syswow64 and click on OK)
Locate Odbcad32.exe & double click on the file
Click on System DSN Tab
You will find the "SymantecEndpointDSN" listed in the window.
Now click on the CONFIGURE button and proceed with the configuration of the DSN for the Symantec Endpoint Protection Manager
- Open ODBC (using instructions above if on a 64-bit OS), then do the following:
Select Configure on the SymantecEndpointSecurityDSN
Under the LOGIN tab set it to Supply User ID and password and type:
User ID: dba
Password: Login password to the SEPM
Under the DATABASE tab configure these options:
Server Name: Name of Server
Database Name: sem5 (if you are using the embedded database)
Under the NETWORK tab configure these options:
Check TCP/IP and enter: "host=IPAddressofServer" without the quotes.
Now test connection. You should receive Connection Successful.
References:
Symantec Endpoint Protection Manager Database Will Not Start
If Symantec Endpoint Protection Manager v11 embedded database does not start, try the following:
References:
http://www.symantec.com/connect/forums/embedded-database-will-not-start
The below article describes how to recreate the embedded database's log file:
http://www.symantec.com/docs/TECH169664
A SEP11 version of the steps is:
Go to "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\" and rename sem5.log to sem5.log.old
Click Start, click on Run and Type "CMD" then click OK
In the Command Prompt type: "CD C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32\" and press Enter this will change directories to the folder containing dbsrv9.exe.
To force the recreation of sem5.log. Type: "dbsrv9 -f "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" and press Enter
Click Start, click on Run and Type "services.msc" then click OK and start the Symantec Embedded Database Service
Start the Symantec Endpoint Protection Manager service.
Don't forget to adjust the paths if your SEPM is on a 64bit OS
References:
http://www.symantec.com/connect/forums/embedded-database-will-not-start
Subscribe to:
Posts (Atom)