Matrix Technical Support Mailer – 64 How to restore database through SQL Management Studio Dear Friends, This mailer will help you to restore database using SQL Management Studio. Introduction: COSEC database can be either MSSQL database or ORACLE database. User can take COSEC database backup and restore it. For SQL database, user can take backup using database Utility and restore using SQL Management studio 2005 or 2008. Prerequisites:  To restore SQL database, SQL Management studio is required  SQL Service should be started  Shared Memory, Name Pipes and TCP/IP should be enabled in SQL configuration manager. Follow mentioned steps to restore COSEC database to other database Configuration Steps: 1. Open SQL Management Studio 2. Select Server Name  Click Browse for more option 3. This will open Browse for Servers window  Expand Database Engine option  Select Server path and click OK 4. Select Authentication Mode Either Windows Authentication or SQL Server Authentication  Windows Authentication: User doesn’t need to provide login credentials; SQL server takes windows credentials for authentication  SQL Server Authentication: Specify Username and Password which have been configured during installation of SQL 5. Click Connect option  This will open Microsoft SQL Server Management Studio Express 6. Click Database option This is the Names of Database available in SQL studio 7. Expand Databases option and right click on the required database for choosing restore option. 8. Click Restore option and select Database option  This will open Restore Database Window 9. Specify source location of backup  Select From Device option  Click Browse icon  This will open Specify Backup Window 10.Click Add option 11.Select Backup file path which should be in .bak format 12.Click OK 13. Enable Restore option  Click Options in Restore Database window  If created database is new then no need to overwrite it  If database contains any data then enable Overwrite the existing Database option 14.Enable Overwrite the existing database and browse for the path of overwriting database if you want to overwrite your existing database C:\program files\microsoft SQL server\Database mdf and ldf files 15.System will execute restore process 16.System will show message ‘Restore of Matrix Database completed successfully’ 17.Click Ok In this way user can restore database from one SQL database file to other SQL database Technical Training Team [email protected] Disclaimer: The information contained in this e-mail and/or attachment may contain confidential or privileged information. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Matrix Comsec Pvt Ltd on any subject matter. Any action taken or omitted on this message is not entirely at your risk and the originator of this message nor does Matrix Comsec Pvt Ltd take any responsibility or liability towards the same. If you are not the intended recipient, please notify us immediately and permanently delete the message.