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

Hai trovato questa risposta utile?

 Stampa Articolo

Leggi anche

Do you support MSDE 2000?

No, we do not support MSDE 2000. The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a...

How can i generate scripts for MS SQL Database?

Your default database user don't have privillages to do that You can just create a support...

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...

Do you have any Web Based Enterprise Manager?

No, we don't have that. You can just use MS SQL Management Studio from your local machine and...

How to connect to SQL Server 2000 using Query Analyser?

...