Portal Home > Knowledgebase > Articles Database > Restoring MSSQL database
Restoring MSSQL database
| Posted by Tomcatf14, 05-05-2009, 01:45 AM |
| Hi,
How can my user use MSSQL management studio to restore the DB? Whenever my user try to browse for the db file, he can't browse to his own web folder due to permission error.
|
| Posted by Collabora, 05-05-2009, 01:58 AM |
| Is the sql b/u in your web folders? Sounds like an issue for the host. The permission issue has nothing to do with ms sql.
|
| Posted by Tomcatf14, 05-05-2009, 02:01 AM |
| What is b/u? It is a default MSSQL 2005 installation. Currently, I have to restore the DB with admin privilege on behalf of my user. How can my user restore it them self?
|
| Posted by Collabora, 05-05-2009, 02:13 AM |
| Where was the backup (b/u) file stored? Can you connect to sql db with management studio?
|
| Posted by Tomcatf14, 05-05-2009, 02:33 AM |
| The backup file is in the user's home directory and the user is able to connect with management studio. However, the user could not browse to the file is the home directory to restore due to permission error. Btw, the user is using MSSQL authentication to login.
|
| Posted by prashant1979, 05-05-2009, 02:50 AM |
| AFAIK, a normal sql user with the public and db_owner permissions to its database cannot restore the database. For that you need the special admin privileges of db_backupoperator.
|
| Posted by Tomcatf14, 05-05-2009, 03:04 AM |
| I need to enable "db_backupoperator" permission for the user?
|
| Posted by Tomcatf14, 05-05-2009, 03:14 AM |
| Enabled the permission "db_backupoperator" but still could not work.
|
| Posted by prashant1979, 05-05-2009, 03:44 AM |
| I am sorry if this was a wrong information. I had heard this somewhere, but had never tried. However, all I know is that the user needs admin level permissions to be able to restore the DB. Tools like MyLittleAdmin provide you the option. Ask your webhost if they provide MyLittleAdmin.
|
| Posted by Collabora, 05-05-2009, 09:39 AM |
| If that's the config, sounds like the restore may need to be done via the provided control panel.
|
| Posted by NancyD, 05-05-2009, 11:21 AM |
| you can restore Mysql database using this syntax in MySql:
mysql - u user_name -p your_password database_name < file_name.sql
example:
mysql - u bobbyjoe -p happy234 BobsData < BobBackup.sql
|
| Posted by NancyD, 05-05-2009, 11:25 AM |
| i hope it will help i also used that syntax when I lost one of my database in my site and I really works..
|
| Posted by arun_kris, 05-05-2009, 10:30 PM |
| This can be done only thro' user with admin privileges. Most of the hosting providers provide myLittleAdmin, ASPEnterpriseManager and allows you to connect remotely through SQL Management Studio Express but for backup/restore option only admins can accomplish this task and can't be done thro' ordinary db users.
Thanks,
Arun
|
Add to Favourites 
Print this Article
Also Read
