I've been going through data corruption from last 2 days in row that .ldf getting corrupted and I've to fix it.
I did my research that I need new server and management studio because whatever we used it's old. Here I am giving you info what we use. Can someone tell me if I upgrade to newer version of SQL Server and Management studio would be my problem resolved? We are using
We are using MICROSOFT WINDOWS Server 2003r2 - Standard X64 Edition service pack 2
We are using SSMS as following version
MICROSOFTSQL Server 2005 - 9.00.5324.00 (X64) Aug 24 2012 18:28:47 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on WINDOWS NT 5.2 (Build 3790: Service Pack 2)
I AM PLANNING TO UPGRADE
I'm planning to upgrade from WINDOW sql server 2003 r2 with 2005 SQL Server Management Studio to WINDOWS sql server 2008r2 with 2012 SQL Server Management Studio so would be resolve my database corruption?