February 18, 2012 at 4:52 am
Hi,
I have used sql server 2000 but I am new to 2005/2008 versions.
I have:
- Sql server 2005 installed on my hosting server.
- Sql server 2008 installed on my local computer.
What is the procedure of downloading complete database from my hosting to my local computer?
Thanks!
Zeeshan
February 18, 2012 at 5:10 am
Take a backup of the hosted database (backup database ....), copy the backup file locally. Restore the backup
Do note that going the other way is not possible, because the local SQL instance is a higher version, and upgrading databases is possible, downgrading them isn't.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2012 at 6:09 am
GilaMonster (2/18/2012)
Take a backup of the hosted database (backup database ....), copy the backup file locally. Restore the backupDo note that going the other way is not possible, because the local SQL instance is a higher version, and upgrading databases is possible, downgrading them isn't.
Fortunately, I just found that the version installed on hosting sql server is 2008. So what should I do to create a backup and restore it to my office computer?
Thanks!
February 18, 2012 at 7:35 am
I'm going to assume that there are management tools installed on the server. From the object explorer in Management Studio, right click the database and chose backup. Once complete copy the backup file to your local machine and, using the management tools on your local machine restore it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply