restore to dasp

Hi

I would like to restore my local bak file to dasp.
I successfully open a connection to my db with sqlExpress.
on my SQL2005_... db I click Tasks/Restore/database
I select the correct To database
but when I try to open the From device i obtain this error (psb)
There is an another way to restore db ?
Thanks
Fred

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

The EXECUTE permission was denied on the object 'xp_fixeddrives', database 'mssqlsystemresource', schema 'sys'.
The EXECUTE permission was denied on the object 'xp_fixeddrives', database 'mssqlsystemresource', schema 'sys'.
The EXECUTE permission was denied on the object 'xp_fixeddrives', database 'mssqlsystemresource', schema 'sys'.
The EXECUTE permission was denied on the object 'xp_fixeddrives', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

For help, click: http://go.microsoft.com/fwlink?Prod...207&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

 

Try using the SQL Management Tool inside your hosting control panel.

Refer to this kb article for more information on our SQL Management Tool.

https://support.discountasp.net/KB/a191/sql-2005-management-tools.aspx

 

Hi

What do you mean by the SQL Management Tool ??
is it SQL Server Management Studio Express installed on my PC ?
If yes I try restore and attach and il all cases I obtain an error like The "EXECUTE permission was denied on the ..."

What do you mean by our SQL Management Tool ??
is it the myLittleAdmin for SQL Server 2005 and 2008 ?
if yes Could you perform a restore or attach in myLittleAdmin ?
If yes HOW ?

Thanks in advance
Fred

 

When you order our SQL addon, you will get a SQL Management Tool feature in your hosting control panel. I'm assuming you are referring to SQL 2005 but its basically the same location in SQL 2008. Basically log into your hosting control panel, on your left hand side navigate to MS SQL 2005. Click on that. It will open up the database managment feature inside your control panel. You will see several tabs in the middle of the screen. Look for the tabl that reads 'SQL Tool Suite'. Thats the SQL Management Tool.

 

thanks - it works perfect !!