Transaction Log - 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 2008 Forums

SQL Server Administration (2008)

Transaction Log

Author

Topic

hanifikri
Starting Member

14 Posts

Posted - 2011-02-25 : 04:23:16

We are in midst of upgrading from sql 2000 to sql2008 r2.
Currently, for our current database, we have two transaction log. So, we would like to have just one transaction log when move to sql 2008 r2.

For your info, these two transaction log have the same size only the names are different.

I need your advise on how to have just 1 transaction log.

thank you.

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2011-02-25 : 11:19:23

From BOL - ALTER DATABASE[CODE]USE master;
GO
ALTER DATABASE AdventureWorks
REMOVE FILE test1dat4;
GO[/CODE]This does assume that no active transactions are present and I don't think that it takes effect until you restart the service.

=======================================
Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986)