Restore a SQL Bak file without local access to database?
Posted on 2006-05-25
This is a really stupid problem, but a problem that I have to solve asap.
I have a bak file that contains the backup of a database. I am running Win XP with SQL Client tools installed. I have a remote database server hosted by some hosting company. I can't restore the bAK file because i dont have permissions. The hosting company wants like 100 bucks to do it.
I can't get access to it on my local machine because my version of sql software (enterprise) will not install a local db on a win xp machine; only a server.
Is there anohter way to get to the stuff in the bak? My ideas...
- SQL Express?
- SQL 2005 demo?
- some 3rd party software?
- someone restore and make me a sql script?? (i would be so happy!)
- any other suggestions?