Home > Backup and Recovery > SQL server 2012 Backup issue and resolution

SQL server 2012 Backup issue and resolution


We have received the below failure for one database at SQL server 2012 64 bit enterprise edition

 

Error:

A database from an earlier version of SQL Server becomes unusable when you attach it to an instance of SQL Server 2012

 

Msg 5901, Level 16, State 1, Line 1

 

One or more recovery units belonging to database AdventureWorksLT2008 failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database corruption. Examine previous entries in the error log for more detailed information on this failure.

 

Msg 9003, Level 20, State 15, Line 1

The log scan number (43607:149:1) passed to log scan in database AdventureWorksLT2008 ‘ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

 

Workaround:

 

http://hotfixv4.microsoft.com/SQL%20Server%202012/nosp/2012_RTM_SNAC_CU2_2703275_11_0_2325_x64/11.0.2325.0/free/453121_intl_x64_zip.exe)

 

Need to be downloading and update the service pack

 

I have attached the below four  link which indicate the KB article for Microsoft® SQL Server® 2012 issue and resolution. All the links are specially for 64 bit edition.

 

Package:

———————————————————–

———————————————————–

KB Article Number(s): 2703275

Language: All (Global)

Platform: x64

Location: (http://hotfixv4.microsoft.com/SQL%20Server%202012/nosp/2012_RTM_SNAC_CU2_2703275_11_0_2325_x64/11.0.2325.0/free/453121_intl_x64_zip.exe)

 

———————————————————–

KB Article Number(s): 2550375, 2554905, 2567366, 2658474, 2665649, 2667211, 2673997, 2675233, 2675522, 2677198, 2678796, 2679342, 2682488, 2682819, 2683304, 2685132, 2685743, 2688968, 2689336, 2689903, 2693652, 2698150, 2699163, 2699820, 2699949, 2699968, 2702015, 2702879, 2703152, 2703275, 2705236, 2705571, 2707166, 2708594, 2710782, 2711145, 2711315, 2711683, 2714785, 2717234, 2717239, 2719217, 2720619, 2720673, 2720678, 2720690, 2720961, 2721122, 2721610

Language: All (Global)

Platform: x64

Location: (http://hotfixv4.microsoft.com/SQL%20Server%202012/nosp/2012_RTM_PPExcel_CU2_2703275_11_0_2325_x/11.0.2325.0/free/449400_intl_x64_zip.exe)

 

———————————————————–

KB Article Number(s): 2550375, 2554905, 2567366, 2658474, 2665649, 2667211, 2673997, 2675233, 2675522, 2677198, 2678796, 2679342, 2682488, 2682819, 2683304, 2685132, 2685743, 2688968, 2689336, 2689903, 2693652, 2698150, 2699163, 2699820, 2699949, 2699968, 2702015, 2702879, 2703152, 2703275, 2705236, 2705571, 2707166, 2708594, 2710782, 2711145, 2711315, 2711683, 2714785, 2717234, 2717239, 2719217, 2720619, 2720673, 2720678, 2720690, 2720961, 2721122, 2721610

Language: All (Global)

Platform: x64

Location: (http://hotfixv4.microsoft.com/SQL%20Server%202012/nosp/SQLServer2012_RTM_CU2_2703275_11_0_2325_/11.0.2325.0/free/449398_intl_x64_zip.exe)

 

———————————————————–

KB Article Number(s): 2550375, 2554905, 2567366, 2658474, 2665649, 2667211, 2673997, 2675233, 2675522, 2677198, 2678796, 2679342, 2682488, 2682819, 2683304, 2685132, 2685743, 2688968, 2689336, 2689903, 2693652, 2698150, 2699163, 2699820, 2699949, 2699968, 2702015, 2702879, 2703152, 2703275, 2705236, 2705571, 2707166, 2708594, 2710782, 2711145, 2711315, 2711683, 2714785, 2717234, 2717239, 2719217, 2720619, 2720673, 2720678, 2720690, 2720961, 2721122, 2721610

Language: All (Global)

Platform: x64

Location: (http://hotfixv4.microsoft.com/SQL%20Server%202012/nosp/2012_RTM_DAC_CU2_2703275_11_0_2325_x64/11.0.2325.0/free/449402_intl_x64_zip.exe

Advertisements
Categories: Backup and Recovery
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: