I have inherited a server with 2 db's on it. In the sysfile table and the database properties/transaction log section the 'file name' is identical in both db's yet the loactions are different. We are having trouble getting the tran log to shrink and have tried the obvious (increased file growth ect.). Could SQL Server be confuing the 2 logs?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sysfile/transaction log file name
- Thread starter gcole
- Start date
tlbroadbent
MIS
It's not likely that SQL Server confuses the databases or logs as each has an ID number used internally by SQL Server. What have you done to shrink the log files? Have you reviewed faq183-1534: Shrinking Databases and Logs - SQL 7 and Higher?
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question