How to restore a database backup file

Hi all,
I have created my database backup (.bak file) now i want to restore it on
discountasp.net. When i upload the back file on server and tried to create a
backup then it gives me following error.
"Failed. Your database has been rolled back. Please contact Technical Support for details."

Could you please help me to solve the proble,
I have created backup of SQL server 2000 database.

Thanks
Rahul

 

Hi Rahul,
I'm definitely interesting in helping you resolve this, as it will help others too.
Can you explain a bit more about the DB?
For example, are bringing a BU from a decommissioned SQL 2000 account to SQL 2008?
All the best,
Mark

 

Hi wisemx,
Actually my site is hosted on another server. Now i am transferring my website from
my existing server to discountasp.net. I have taken database backup from my current server and trying to restore on discountasp.net. We have purchased purchased SQL server
2005 database.

Thanks

 

Hi,
Do you have a local SQL Server toolset? (IDE, etc.)
There are free tools here: http://www.codeplex.com/site/search?projectSearchText=SQL
...You can use to script the entire DB and records.
The easiest and what I find to be safest is to have a local SQL Server you use to pull tables and records in from anywhere then pump them to your remote server of choice.
I'm not sure but I don't thing the DASP Control Panel can be used to restore BUs from outside servers.
You can however get your DB and all objects transferred by using relatively simple tools.
(Including the Web based SQL Admin "MyLittleTools" linked in your Control Panel)
All the best,
Mark

 

Hi wisemx,
yes i have. Did you mean i need create a script which will transfer the entire DB and records using the tools provided in link.
Am i right?

Thanks

 

Hi,
If the Restore will not succeed and you don't have a local SQL Server, yes, I do believe generating scripts for everything will be best...
A lot of DBAs still do it that way, they don't trust the SSIS tools, which will miss your SPs and translate your VIEWs.
But with SQL Scripting tools, in SQL Server or with those I linked to, you can Script and restore everything, maybe not easy of course.
Note: If you're in a pinch I am willing to do this for you, you would only need to trust me. ;-)
All the best,
Mark

 

Hi wisemx,
But i have Local SQL server. How can i do it with local SQL server?

Thanks

 

Hi,
This part is easy for you if that is the case. ;-)
Use the Import/Export tools, from Tasks when you right-click on Database name.
It more than likely won't catch everything but it should retain relationships.
I've used it on servers here to move SQL Server DBs from Forum packages successfully.
Then for anything it missed just make a connection to your remote SQL Servers in the same SQL Server IDE and generate scripts.
Simple as pasting and clicking the Execute button to run the script.
SQL Server Management Studio can generate all the scripts for you to create objects.
All the best,
Mark

 

Hi wisemx,
It only create the tables, but what about the data in my database. How can i export all the data to my new database?

Thanks

 

Hi,
I recently recorded a video of SQL Server 2008 using this to Export all tables and records.
http://silverlight.services.live.com/49023/SQL Server 2008 - Export to remote/video.wmv

(Best to view that in IE...Windows Media, Silverlight Streaming.)

With SQL Server 2005 the method was the same but you at times needed to 'check' options like "Optimize for many rows", still if you step through each part of the Import/Export wizard it should copy your tables and the records in them.
I'll do what I can to help you with this but it should be a few simple clicks on your end at this point. ;-)
All the best,
Mark