How to restore my mssql database?

Old control panel

-    Upload the backup file in .zip extension onto your root folder

-    Log into your control panel -> MSSQL database -> tools(beta) -> select the database on the dropdown menu -> type in the backup file in .zip extension which has been uploaded onto your root dir -> click on the restore button

New DNP Control Panel

-    Log into DNP

-    Click on the database -> SQL 2008 / 2005

-    Click on the database name

-    Expand the maintenance tools section

-    Click on restore

-    Select the restore path and filename

Was this answer helpful?

 Print this Article

Also Read

How do I configure the SQL Server Client connection protocol?

To connect to a remote MS SQL Server over the Internet using SQL clients (Enterprise Manager,...

How do I get a copy of MS SQL Enterprise Manager and Query Analyser?

Microsoft does not distribute MS SQL client tools individually, they are bundled with MS SQL...

How to connect to SQL Server 2000 using Query Analyser?

...

How do I access SQL Server 2008 Database using SQL Server Management Studio?

Please follow the steps listed below in order to access or connect your SQL 2008 database using...

Can I use mssql 2008 if I built my database using mssql 2005?

Yes you can use the mssql 2008 although you build your db using mssql 2005. The database can be...