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 |
|
dtrivedi
Posting Yak Master
153 Posts |
 Posted - 2011-03-31 : 08:47:54
|
| I have a database that I need to move from my sql express to someone else's local instance. the size is 3.41 MB how can i do this? |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2011-03-31 : 08:50:57
|
do a backup of yours, then a restore on the other instance.Corey I Has Returned!! |
 |
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2011-03-31 : 08:56:57
|
| yeah that's what i thought...can alternatevly use SQL server import and export wizard so i dont have to go to his computer? |
|
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2011-03-31 : 09:03:58
|
| ok if i back it up it won't let me choose a nother destinatetion besides c:/ what can I do? |
|
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2011-03-31 : 09:08:58
|
| is there a way to put it on my share drive? |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-03-31 : 10:50:31
|
| BACKUP DATABASE yourDBNamehere TO DISK = 'd:\' -- OR ANY OTHER PATH--------------------------http://connectsql.blogspot.com/ |
|
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-15 : 15:42:21
|
| Deattach the database and copy all files on the shared drive then attach back to your own instance and then attach the shared one on another serveryou can stop the sql server service too then copy it and then start it againRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA |
|
|
|
|
|
|
Moving database from my local to someone else's