October 4, 2011 at 3:14 pm
How to verify the VLF is active or inactive?
thanks
October 4, 2011 at 3:22 pm
execute DBCC LOGINFO() against your database to view details of the transaction log(s)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2011 at 3:39 pm
......those with a status of 2 are active
---------------------------------------------------------------------
October 4, 2011 at 10:24 pm
For more info check the links in my sig for Kimberly Tripp.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 5, 2011 at 1:13 am
SQLRNNR (10/4/2011)
For more info check the links in my sig for Kimberly Tripp.
Hmm, it is a good article, although I don't agree with Kimberleys statement that detaching a database is the best way to move a file (except if you're using SQL server 2000) and that RAID 0+1 can offer better performance than RAID 1+0
It doesn't actually tell you how to identify active portions of the log unti you get to the near bottom of the article and if you don't read it carefully you're likely to miss the 2 liner 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 8:44 am
Perry Whittle (10/5/2011)
SQLRNNR (10/4/2011)
For more info check the links in my sig for Kimberly Tripp.Hmm, it is a good article, although I don't agree with Kimberleys statement that detaching a database is the best way to move a file (except if you're using SQL server 2000) and that RAID 0+1 can offer better performance than RAID 1+0
It doesn't actually tell you how to identify active portions of the log unti you get to the near bottom of the article and if you don't read it carefully you're likely to miss the 2 liner 😉
RAID perf - that one is kind of a test and test again with your disk setup (# spindles). I can see it both ways.
I don't disagree with the move of a file - as long as it is a copy and not full on move until after it has been brought online at the destination. This is another case of it depends.:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 5, 2011 at 8:56 am
with SQL Server 2000 pretty much the only way to move a file was to detach. With SQL Server 2005 and later the ALTER DATABASE MODIFY FILE solution is in my opinion much better. You can issue the file location change which will not take place until the database is restarted. Offline the database, move the file and then online it again.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply