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 to connect to SQL Server 2000 using Query Analyser?

...

I get "The server principal "username" is not able to access the database "databasename" under the current security context. (Microsoft SQL Server, Error: 916) " after I tried to login via MS SQL Management Studio?

To fix this SQL Server Management Studio 2008 bug please do the following: Open SQL Server...

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 to use SQL Management Studio Express 2005?

Open your SQL Management Studio Express 2005 on your local machine.Step 1) Type the ServerName:...

How do I find my MS SQL Server or Host Address?

Please follow these steps below to obtain that information : Login to your DotNetPanel :...