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 [...]
Category Archives: Backup and Restore
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 [...]
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 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 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 [...]