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

Esta resposta lhe foi útil?

 Imprimir este Artigo

Veja também

How do I obtain the MS SQL database disk usage?

Execute this command in Sql Query Analyzer exec sp_spaceused The database size is measured in...

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

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

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 to connect to SQL Server 2000 using Enterprise Manager?

To connect to your Microsoft SQL Server database using Enterprise Manager to manage your...