But when i right click at database, properties, unable to see option. Hi FernandaAraujo, just create a maintence plan with a regular backup of transaction log, it will keep your LDF file at minimum size.
To continue this discussion, please ask a new question. Which of the following retains the information it's storing when the system power is turned off? Submit ». Get answers from your peers along with millions of IT pros who visit Spiceworks. Hey guys, I had one of my remote offices call me as they were onsite. System running on Windows Server R2. This 40GB log file consumed the rest of the diskspace on the drive. Best Answer. Verify your account to enable IT peers to see that you are a professional.
Chances that something get wrong while changing recovery mode are pretty thin. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account.
Notify me of new comments via email. Notify me of new posts via email. RSS - Posts. RSS - Comments. Kerseub's Blog Sharepoint, Claims authentication and other. Net Headaches.
Home About. Last Updated: Jun 18, 2 Minute Read. Reply 2. Facebook Twitter Reddit LinkedIn. Royce Wilkerson. Main Areas of Contribution:. Track Progress. Earn Credits. Varinder Sandhu. Monday, June 1, PM. First of all check the recovery model of your database. If it is simple then just follow the intrunctions provided by other previous posters.
And also check what process is cuasing it and modify the process accordingly. Wednesday, June 3, AM. It will invalidate all forthcoming transaction log backups until the next database backup. That might open an unacceptable vunerability of the system.
Managing size of transaction log and backups go hand in hand in SQL Server.
0コメント