Posts Tagged Database

Shrink log size in sql database

Posted by Le Kevin in Database on June 12, 2009

To shrink the file size I use the following script:

Use DBName
Go
exec sp_dboption DBName, ‘trunc. log on chkpt.’, true
checkpoint
DBCC SHRINKFILE (N’DBNameFileName, 0);
exec sp_dboption DBName, ‘trunc. log on chkpt.’, false

Share|

, , , ,

No Comments

Restore database users in MS SQL SEVER

Posted by Le Kevin in Database on October 16, 2008

This is for when you restore a database and want to hook the users in the new database to the users with the same name in the SQL Server

login to the db as SA

exec sp_change_users_login ‘Auto_Fix’, ‘dbName’

Share|

, ,

1 Comment