Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dhaliwal
Starting Member
5 Posts |
 Posted - 2007-09-20 : 06:55:50
|
Hi there,This is my first post in these forums. Actually i am having some problem in transfering Database from one server to another.From my source server, i have managed to make a .BAK file(size Around 1.5 GB) through SQL Backup. Now i have that file on my local machine. I want to transfer that database to another remote machine. I tried 1 thing: i restore that .bak file to my local machine and tried to use export utility...... it started uploading. but after some time. it shows the following error. I am from programming background. and i am not sure that what i am trying to do is the best solution for my problem. Can you please suggest me any method with which i can acomplish this task. And if i am going right then can u please tell me where i am going wrong.I am using SQL Server 2005. and i want to transfer the full Database including all the objects i.e. Store Procedures, triggers etc.Thanks AlotGurpreet Singh Dhaliwal |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-09-20 : 09:26:32
|
| For some reason th error isn'r showing . One thing you could try is : make sure the db is set up on the rempote machine, then do a transfer data , where one of the options is to transfer all the objects plus dataJack Vamvas--------------------Need an IT job ? http://www.ITjobfeed.com |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-09-20 : 10:56:49
|
| When did "2" become a preposition?CODO ERGO SUM |
|
|
|
Kristen
Test
22859 Posts |
|
|
Dhaliwal
Starting Member
5 Posts |
Posted - 2007-09-22 : 02:21:07
|
quote:
Take a SQL Backup.Copy the BAK file to the remote machine (Copy, FTP or put it on a CD!)Restore the BAK file on the remote machine.For help with the syntax of the Restore command see:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example,Restore
Thanks every body for replying. But i think that i dont have permission of Restore Command on server...... So i think that it leaves me Import/Export the only option.Any other suggessions. ORCan any body give me a link to an articles that explains how to transfer a heavy db on a remote machine.Any kind of help would be Appreiciated.ThanxGurpreet Singh Dhaliwal |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-22 : 02:49:05
|
| I think you best bet is to get permissions granted, or to get someone with permission to do it for you.Transferring huge volumes of data with Import is going to be slow ... as you have found out!Using BCP to create an Export file at the remote server, and then importing that (with BCP) would probably be OK, but you still have the problem of getting the file ... and if you can't get a BAK file presumably you can't get a TXT file, made by BCP, eitherKristen |
|
|
|
|
|
|
|
|
Whats the best way 2 transfer DB to remote machine