Tag: SQL Server 2005

Data Protection Manager 2010 error ID 30140 Details: Internal error code: 0x80990D11

I get the following error in DPM Management console on a SQL2000 server that is protected with DPM 2010

Affected area:           

Occurred since:          8/20/2011 4:01:13 AM

Description:    Recovery point creation jobs for SQL Server 2000 database ?????? on ???? have been failing. The number of failed recovery point creation jobs = 3.

If the datasource protected is SharePoint, then click on the Error Details to view the list of databases for which recovery point creation failed. (ID 3114)

DPM tried to do a SQL log backup, either as part of a backup job or a recovery to latest point in time job. The SQL log backup job has detected a discontinuity in the SQL log chain for  SQL Server 2000 database ???? since the last backup. All incremental backup jobs will fail until an express full backup runs. (ID 30140 Details: Internal error code: 0x80990D11)

More information

Recommended action:           If you see this failure as part of a backup job, then in the Protection task area, select the SQL Server database and click Create recovery point. Choose express full backup. Alternately, you can wait for the next scheduled express full backup to run.

If this failure occurs as part of a recovery job, then try to recover from another point in time.

Review the Application Event Viewer logs on the computer running SQL Server for more details.

Ensure that this database is not already protected by another backup application.

Create a recovery point…

Resolution:     To dismiss the alert, click below

Inactivate alert

Solution:

DPM tried to do a SQL log backup, either as part of a backup job or a recovery to latest point in time job. The SQL log backup job has detected a discontinuity in the SQL log chain for SQL Server 2005 database database <name database> since the last backup. All incremental backup jobs will fail until an express full backup runs. (ID 30140 Details: Internal error code: 0x80990D11)

Resolution: It seemed that the problem was that there were also backups performed straight from the SQL Management Studio. Stopping these backups resolved the issue. See also http://support.microsoft.com/kb/970642

Microsoft Application Compatibility Toolkit (ACT)

The Microsoft Application Compatibility Toolkit (ACT) 5.5 is a free tool from Microsoft. It helps customers understand their application compatibility situation by identifying which applications are compatible with the Windows 7 RC and Windows Vista® operating system and which require further testing. ACT helps customers lower their costs for application compatibility testing, prioritize their applications, and deploy Windows more quickly. You can use the ACT features to:

  • Verify an application’s compatibility with a new version of the Windows operating system, or a Windows Update, including determining your risk assessment.
  • Become involved in the ACT Community, including sharing your risk assessment with other ACT users.
  • Test your Web applications and Web sites for compatibility with new releases and security updates to the Windows® Internet Explorer® Internet browser.

Software Requirements:

Type of Software Type of Software
Operating Systems – Windows 7
– Windows Vista
– Windows Vista with Service Pack 1 (SP1)
– Windows XP with Service Pack 2 (SP2) or Service
   Pack 3 (SP3)
– Windows Server 2003 with Service Pack 2 (SP2)
– Windows Server 2008 R2
Database Components – Microsoft SQL Server 2008
– Microsoft SQL Server 2005
– Microsoft SQL Server 2008 Express
– Microsoft SQL Server 2005 Express
.NET Framework – ACT requires the .NET Framework 2.0 or newer.

Download HERE
image

Microsoft Assessment & Planning Toolkit

The Microsoft Assessment and Planning (MAP) Toolkit is an agentless toolkit that finds computers on a network and performs a detailed inventory of the computers using Windows Management Instrumentation (WMI) and the Remote Registry Service. The data and analysis provided by this toolkit can significantly simplify the planning process for migrating to Windows® 7, Windows Vista®, Microsoft Office 2007, Windows Server® 2008 R2, Windows Server 2008, Hyper-V, Microsoft Application Virtualization, Microsoft SQL Server 2008, and Forefront® Client Security and Network Access Protection. Assessments for Windows Server 2008 R2, Windows Server 2008, Windows 7, and Windows Vista include device driver availability as well as recommendations for hardware upgrades.

You can use MAP to inventory the following platforms:

  • Windows 7
  • Windows Vista
  • Windows XP® Professional
  • Windows Server 2008 or Windows Server 2008 R2
  • Windows Server 2003 or Windows Server 2003 R2
  • Windows 2000 Professional or Windows 2000 Server
  • VMware ESX
  • VMware ESXi
  • VMware Server

Reporting
– Identification of currently installed Windows client operating systems, their hardware, and recommendations for migration to Windows 7 and Windows Vista. The tool also reports if desktops have anti-virus and anti-malware programs installed and if the Windows Firewall is turned on.
– Identification of currently installed Windows Server operating systems, their hardware, and recommendations for migration to Windows Server 2008 R2 and Windows Server 2008.
– Identification of currently installed Microsoft Office software and recommendations for migration to Microsoft Office 2007.
– Detailed assessment and reporting of server utilization gathered using the Performance Metrics Wizard.
– Recommendations for server consolidation and virtual machine placement using Hyper-V
– Assessment of client machines, servers, and the technology environment for the implementation of Microsoft Application Virtualization (APP-V)
– Identification of machines where Microsoft SQL Server components are installed.
– Identification of virtual machines, their hosts, and details about each.
– Identification of Windows Server Roles

Hardware Requirements:
– Windows 2003 x86/x64 or Windows 2008 x86/x64
– 1,5 GB (2 GB 2008)

Software Requirements:
– NET Framework 3.5 SP1
– Windows Installer 4.5
– Microsoft Office Word 2007 or Word 2003 SP2
– MIcrosoft Office Excel 2007 or Excel 2003 SP2
– SQL Server 2008 Express Edition, SQL Server 2008, or SQL Server 2005

image image
image image

Download Microsoft Assessment and Planning (MAP) Toolkit HIER

SQL 2005 Management Studio Database Backup

 

In het volgende artikel legt ik uit hoe je beste een database kunt backup met SQL Server 2005 Management Studio. De uitleg betreft een full backup. De backup wordt opgeslagen als een .bak bestand.

1. Open SQL Server Management Studio.
2. Connect naar MS SQL Server database.
clip_image001
3. Klik met rechtermuis knop op de database en kies voor Tasks en kies vervolgens Backup.

clip_image002

4. Onder Backup Type: kies voor full.

clip_image003

5.Klik eerst op Remove Onder Destination en klik vervolgens op Add.
6. Geef vervolgens aan waar de bestand opgeslagen moeten worden en vergeet niet .bak mee te geven.
clip_image004

7. Klik op OK.
8. Controleer nogmaals of dat je alles goed ingesteld hebt.

9. Klik op OK om de backup te starten.

Translate »