Reducing log device size - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Reducing log device size

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-10-09 : 10:18:03

Shishpal Singh writes "My Data device size is 200MB but log device size is 3GB.

Why it is happened...?

Now I want reduce the log device size. Is it possible...?

If yes then please explain me what is procedure..?

Regards

Shishpal Singh"

1fred
Posting Yak Master

158 Posts

Posted - 2002-10-09 : 10:46:54

Take a look at these two articles
http://www.databasejournal.com/features/mssql/article.php/1460151
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9792

Or just right click on you DB choose all tasks and backup your DB then you can shrink your DB.

scottpt
Posting Yak Master

186 Posts

Posted - 2002-10-10 : 16:04:20

RUN "dbcc shrinkfile ({log_file_name},{size MB})

then back up DB.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources