LDF file Size is so increased
-
ALTER DATABASE [your-database-name] SET RECOVERY SIMPLE;
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
how can i check the old recovery model? i try to change it from DB options but after changing to simple LOGS backup is not possible. DB is showing its size 221GB including LDF size.. Any suggestion to get out from this issue.
-
No i am not using replication
Try running the following query:
SELECT
[name],
recovery_model_desc,
log_reuse_wait_desc
FROM
sys.databases
WHERE
[name] = 'YourDatabaseName'Compare the value returned to the list on TechNet: Factors That Can Delay Log Truncation[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Try running the following query:
SELECT
[name],
recovery_model_desc,
log_reuse_wait_desc
FROM
sys.databases
WHERE
[name] = 'YourDatabaseName'Compare the value returned to the list on TechNet: Factors That Can Delay Log Truncation[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
running this query, i come to know that log_reuse_wait_desc is REPLICATION. what should i do next ?
-
running this query, i come to know that log_reuse_wait_desc is REPLICATION. what should i do next ?
Is your database set up for replication? If so, the replication is broken and you'll need to fix it. If it's not set up for replication, then you'll need to remove the replication settings. Try sp_removedbreplication[^]:
EXEC sp_removedbreplication 'YourDatabaseName'
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Is your database set up for replication? If so, the replication is broken and you'll need to fix it. If it's not set up for replication, then you'll need to remove the replication settings. Try sp_removedbreplication[^]:
EXEC sp_removedbreplication 'YourDatabaseName'
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
Thank you so much its work for me. thank you so much for you cooperation.
