sql server 2008 log file ending in_1 instead of _log, why, can I change back to log?
Posted on 2012-04-04
I was trying to truncate log file using the following which has worked in the past:
ALTER DATABASE "CUSTOMER" SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(N'CUSTOMER_log', 1)
ALTER DATABASE "CUSTOMER" SET RECOVERY FULL WITH NO_WAIT
But I find some of the databases log files end in _log and other end in _1. How did the _1 get assigned. When I change the file name in the DBCC command to _1 it does not work.
Can I rename the log file from _1 to _log? and change this in the Properties->File for the database? Does this cause any other issues?
Need better understanding of why this is happening and how to correct?