9 Mar 2010

Reset admin password SEP Manager

If you have lost the password to login to the SEPM then Run the RESETPASS.bat file from the command prompt In the command prompt go to
c:\program files\Symantec\Symantec Endpoint Protection Manager\tools\resetpass
When you'll hit enter you'll see ENGLISH
Close the command prompt Try logging into the SEPM username:admin
password:admin
Then you will get a promt to change the password

20 Nov 2009

Shrink SQL 2000 log file



BACKUP LOG MyDatabaseName WITH TRUNCATE_ONLY


DBCC SHRINKFILE(MyDatabaseName_log, FileSize)

(where MyDatabaseName_log is the logical file name, and is the target size in MB)

The log file has now been shrunk.

Note that the log file will start expanding in normal operation, depending on the way the database is defined. Make sure that the transaction log file is big enough to store all transactions for the normal period between backups. Makes sure that you take peak system loads into consideration when determining the target size.
 

Regular log file maintenance
In normal operation, you would normally never shrink the log file. Regularly backing up the log file will remove the data used in it, and maintain free space for new transaction.

Total Pageviews