October 7, 2007 at 3:46 am
Hello,
I've created an mssql datbase on localhost and purchased some webspace with mssql support.
I've used the 'backup' option and it outputted a file without extension. how can I import data to the webhost's db server?
I'm able to connect to the remote db host sucessfully. but I can't get the 'extensionless backup file' to be restored into the remote database.
any help?
thanks.
October 7, 2007 at 8:46 am
use a query window in management studio
Check out Restore database in BOL.
restore database yourdatabase
from disk='\\yourfirstserver_UNC\path\backupfile'
-- with move if you want to use new filepaths for mdf and ldf
Your new server's service account needs to be able to read the backupfile (windows authority )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 7, 2007 at 11:54 am
thanks for your reply 🙂
my website is located in the server's "D:\Domains\" folder. so if the backup file name is backup.abc, can I use the query like this?
restore database yourdatabase
from disk='d:\domains\mydomain\backup.abc'
also the backup file has no extension. what is it's format type. I got the file by right clicking the database->tools->restore.
Thanks again 🙂
October 7, 2007 at 11:53 pm
- first of all you have to be sure you've got a valid backup.
maybe even create a new backup using the backup panels.
(tick "validate backup at the end of backup" !)
- then you can restore like you mentioned.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2007 at 3:47 pm
The extension doesn't matter to SQL Server. Usually .bak is used for organizational purposes, but it can be anything.
October 9, 2007 at 6:44 am
The backup extension doesn't matter to SQL server, but it might matter to your hosting company's SQL server interface.
You can try renaming the backup file so that is has a BAK extension.
More likely is that the physical files need to be located in a different directory than the one from which the backup was taken, so it may not work without the help of your hosting company.
Did you get an error message when you attempted the restore?
October 9, 2007 at 2:07 pm
Jeff Gray (10/9/2007)
The backup extension doesn't matter to SQL server, but it might matter to your hosting company's SQL server interface.You can try renaming the backup file so that is has a BAK extension.
More likely is that the physical files need to be located in a different directory than the one from which the backup was taken, so it may not work without the help of your hosting company.
Did you get an error message when you attempted the restore?
I've tried to restore using the query given by ALZDBA (thanks btw)
restore database yourdatabase
from disk='\\yourfirstserver_UNC\path\backupfile'
I've got a permission issue. I've written a note to the hosting company.. but no reply so far.
thanks for all your help guys.. I'll try it again once I get a reply from the hosting company.
thanks again
🙂
October 10, 2007 at 3:40 am
maybe you're better off ftp-ing the backup file to a local drive of your target sqlserver server.
And the just perform a local restore without having to provide extra privileges to the sqlserver service account.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply