Skip to main content

Posts

Showing posts with the label Connect to server

SQL database Data backup files with Bak Extension

SQL Table Data backup Enter in the Data server. Go to Start > Programs > SQL server 2005 > Click on SQL Server management Studio > Click on Connect > Database > select the database ( i.e. AXTESTDATABASE) . Right click on the Database. Click on ā€œTaskā€. > Click on Backup. Click on SQL server management Studio. A window of ā€œConnect to serverā€ will appear.Click on ā€œConnectā€. SQL Server Management Studio will open.Click on ā€œDatabasesā€ & select the appropriate database whose back-up to be taken.Right click on the data base. Click on Task & then click on ā€œBackupā€. After clicking on Backup option, Backup database form will open. System by default will give one backup destination. The same destination can be changed with the help of ā€œRemoveā€ & ā€œAddā€ button. Click on OK to start the back-up.