- Computer Using
- Windows
- Browser
- How-To
- Microsoft Office
- MS Word
- MS Excel
- MS Outlook
- MS PowerPoint
- Graphic / Design
- Photoshop
- Illustrator
- Server & Network
- Computer Networking
- Internet
- Windows Server
- Web Development
- HTML
- Javascript
- CSS
- ASP.NET
- PHP
- Animation
- Flash
- Silverlight
- Database
- Database System
- SQL Server
- T-SQL
- XML
- XML
How to Backup Database in SQL Server 2005
If your hard disk drive was crashed, the database will be lost. Back up database is a way to save your database. It help you by restore the last database that you have been back up.Backup and restore operations are an integral part of the AnalysisServices infrastructure. In Microsoft® SQL Server™ 2005 AnalysisServices, the backup operation has been completely rebuilt.
Let’s take a look at following diagram that shows the interaction between Analysis Services and backup and data files:
Backup and restore are done by issuing XML for Analysis commands against Analysis Services.
After receiving a Backup command, Analysis Services determines which files need to be packages in the single backup file. It will take care of the consistency of the database at the time of the backup and restore. It will make sure that all the objects in the backup file are of the same version.
It is also important to mention the granularity of backup and restore. You back up the entire Analysis Services database into a single file and restore the entire database as well.
back up UI
- Start SQL Server Management Studio.
- Open the connection to the Analysis Services server.
- Right-click the database to back up and select Tasks and point to Back up
- Enter the name and the location for the back up file.
- Click button OK to finish your back up.
BACKUP DATABASE [Northwind] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\Northwind.bak' WITH NOFORMAT, NOINIT, NAME = N'Northwind-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO