3 Replies - 865 Views - Last Post: 18 July 2012 - 01:08 PM

#1 _HAWK_  Icon User is offline

  • Master(Of Foo)
  • member icon

Reputation: 956
  • View blog
  • Posts: 3,676
  • Joined: 02-July 08

Server database restore from local computer.

Posted 17 July 2012 - 03:16 PM

I has a web hosted server where I added a database. Is there a way to use a database in SSMS to create/restore the server database with schema and data. I have tried to backup the Db I want and use the restore task while I have a connection to the server. I get the following error.

Posted Image

I type the correct path in the next dialog and it fails.

Is This A Good Question/Topic? 0
  • +

Replies To: Server database restore from local computer.

#2 thava  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 172
  • View blog
  • Posts: 1,560
  • Joined: 17-April 07

Re: Server database restore from local computer.

Posted 18 July 2012 - 02:47 AM

i have some suggestion,
1) where is the file, is it in Server or in the local machine, if it is in the local machine transfer it to the server and choose the path where you transfer
2) check you have the read permission for that file
Was This Post Helpful? 0
  • +
  • -

#3 _HAWK_  Icon User is offline

  • Master(Of Foo)
  • member icon

Reputation: 956
  • View blog
  • Posts: 3,676
  • Joined: 02-July 08

Re: Server database restore from local computer.

Posted 18 July 2012 - 06:12 AM

The backup db file is on the local machine created from SSMS. The DB on the server was an empty DB file that I could connect to with SSMS. I am not good at setting permissions on the DBs. The server DB has 2 logins sa and the one I created - the web host does not allow me to see the sa account, and I can use my login just fine. I have been having such a hard time I decided to rebuild the tables in SSMS instead, but would still like to know how to do this via the restore option if poss.
Was This Post Helpful? 0
  • +
  • -

#4 thava  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 172
  • View blog
  • Posts: 1,560
  • Joined: 17-April 07

Re: Server database restore from local computer.

Posted 18 July 2012 - 01:08 PM

you need to transfer the database backup to the server other wise there is no chance to restore the empty db with your current backup, there is an another option you can transfer the db through the scripts, you can generate scripts for the entire database, and just run the script in the server, you can also include some insert script for some predefined data's

see this link
SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects


SQL SERVER – 2005 – Generate Script with Data from Database – Database Publishing Wizard
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1