Category Archives: Backup and Restore

How to Restore only Corrupted pages from a database backup ? VIDEO

How to Shorten the recovery time in case of database corruption? PAGE Level database restore is new feature which was introduced in SQL Server 2008 onwards. This is a new feature in SQL Server 2008, where we can restore only some corrupted pages from a good database backup. For example you have a 100 Gb [...]

Backing Up an Analysis Services Database

How to Backup Analysis Services Database ? Backing up Analysis Services database, lets administrators save a particular state of a SQL Server Analysis Services database and its objects. We can take Analysis Services Database Backup in various ways Manually, graphically using SQL Server Management Studio Manually, using a XMLA command / script Schedule a Analysis [...]

Create a XMLA for SQL Analysis OLAP Database Backup

What is Script to take OLAP Database backup manually ? How to Backup Analysis Services Database ? YES, we can create a XMLA script to backup OLAP database . Backing up Analysis Services database, lets administrators save a particular state of a SQL Server Analysis Services database and its objects. We can take Analysis Services [...]

How to Restore Database in SQL Server 2011 (Denali) from an older SQL Server version?

How to restore Database in SQL Server Denali from a backup file, which was created in older version? Restoring a database from an older version to Denali is pretty Simple, and same as of previous versions. Backup’s can be restored with RESTORE DATABASE TSQL Statement. I restored databases on Denali CTP1, from backup files, which [...]

What is importance of Resource DB in SQL Server?

What is Resource Database and what is holds ? The resource database (mssqlsystemresource) database is the new system databases available in SQL Server 2005 and above. The Resource database is a read-only, hidden system database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are [...]

Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL Server 2005?

Yesterday, this question was asked by one of the training participant, Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL Server 2005? No, It is not possible to restore a database from a backup of a newer version because SQL Server 2008 database backups are not [...]