Try the following code through your Query Analyser to shrink the database.
backup log
use database_name
dbcc SHRINKFILE (database_name_Log,2)
dbcc ShrinkDatabase (database_name, 2)
Karthik K | ASP.Net, C#.Net, VB.Net, SQL Server...
Try the following code through your Query Analyser to shrink the database.
backup log
use database_name
dbcc SHRINKFILE (database_name_Log,2)
dbcc ShrinkDatabase (database_name, 2)
No comments:
Post a Comment