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.
| Author |
Topic |
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
 Posted - 2014-06-11 : 19:14:57
|
How does one determine which log file is considered to be the "primary"? Is it simply the one with the lowest sys.database_files.file_id value?Many thanks.
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-06-12 : 01:44:59
|
| If you attempt to delete the primary log file - you should get a 5020 error.Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-06-12 : 12:33:14
|
I have tried to delete the primary log file and it does, indeed, yield an error. What I'm actually trying to accomplish is to proactively detertmine which log files are dropable and clean them up. I could give you the details of how I came to be in this situation but its a long, incredibly boring story. It suffices to say that the main log file is no longer considered the primary and the "temporary" additional log file (on another disk drive) has become the primary. I believe that this happened when the database was restored to a new server location. This particular entanglement I have resolved. Moving forward, I have an administrative task which looks for and removes "temporary" log files. It made the erroneous assumption that the primary log file would be on the designated Log drive. I'd like to alter the logic to explicitly exclude the "primary" log file but I can't find documentation on how to determine the "primary" attribute.
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-06-12 : 16:57:32
|
You are truly amazing... Is there anything that you don't know? Thank-you.
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-12 : 17:02:54
|
quote:
Originally posted by Bustaz Kool
You are truly amazing... Is there anything that you don't know? Thank-you.
 Glad to help!Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
How to find "Primary" log file