Software development team leader specialising in Microsoft Visual C# and C++ from the Northwest of England. Experience working in a globalised business and team; understanding of enterprise business operation and practices; experience reporting to executive management Skills in numerous languages and technologies; knowledge of formal software development lifecycle; experience of architecture design
First find the filename labels for your database:
select name from <DatabaseName>.dbo.sysfiles
Next truncate the log:
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
Finally shrink the database based on the log file in step 1:
DBCC SHRINKFILE('NameAbove_log',2048)
2048 is the resultant file size in MB.
posted by . @ 12:44 PM
Subscribe to
Posts [Atom]
0 Comments:
Post a Comment
<< Home