Refresh The OLD

Nas commands (SQL Server)

To install an new nas service
nassql appservername=service name, installasservice

To uninstall a nas service
nassql appservername=service name, uninstallasservice

Nas Debug command

nassql debug,appservername=”YourNASName”,servername=”SQlServerName”,
database=”YourDatebase”,company=”YourCompany”,startupparameter=”Yourstartupparameter”,
objectcache=32000,nettype=tcp

Shrinking the Log File

Simple Recovery Model
DBCC SHRINKFILE (  databasename_Log, 1)
Full Recovery Model

BACKUP LOG  databasename  WITH TRUNCATE_ONLY
DBCC SHRINKFILE (  databasename_Log, 1)
Alter and then shrink

In management studio:
•Right-click the database, choose properties, then options.
•Make sure “Recovery model” is set to “Simple”, not “Full”
•Click Ok
•Right-click the database again, choose tasks -> shrink files
•Change file type to “log”
•Click ok.

Alternatively – Command
ALTER DATABASE mydatabase SET RECOVERY SIMPLE
DBCC SHRINKFILE (mydatabase_Log, 1)

Ref: http://msdn.microsoft.com/en-us/library/ms189493.aspx

Still to come…………..