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 |
|
jennypretty
Yak Posting Veteran
96 Posts |
 Posted - 2004-10-08 : 08:42:33
|
| Hello friends,I created an sql db and want to upload to the server (thru a hosting company server), I saw two files and don't know which one to upload to.I look at this path c:\program files\microsoft SQL Server\MSSQL\dataI saw two files, jennyDB_Data and JennyDB_Log, which one should I upload to the server? which one is the right one?The db name that I created is JennyDB, but I don't see this db name on the path above.Do you know where I can find this db name?Thanks.The stupid question is the question you don't ask.www.single123.com |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-10 : 09:57:41
|
| if you haven't renamed or changed any of the settings when you created the database, the jennydb_data and jennydb_log are what you're looking for.what do you mean by upload to server?if this database is already existing and you just need to transfer it from one server to another, i suggest you just detach the files, copy them to the new server and attach the mdf files.elseyou can create a backup, then restore to the new server. |
 |
|
|
jennypretty
Yak Posting Veteran
96 Posts |
Posted - 2004-10-12 : 13:00:00
|
| what do you mean by upload to server?I have an asp script file and sql as backend. I link my website thru a hosting company, supporting Access and SQL. When I used Access, it is very easy. Just upload the db to db folder from the host server. Right now, I migrate to sql, So, I don't know which one to upload the host server?Thanks.The stupid question is the question you don't ask.www.single123.com |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-12 : 14:51:30
|
| Presumably your hosting company lets you access the database using Enterprise Manager? if so upload a backup of the database to your FTP area, and then restore from that file, into your SQL database, using Enterprise ManagerKristen |
|
|
|
jennypretty
Yak Posting Veteran
96 Posts |
Posted - 2004-10-13 : 09:25:57
|
| No, I can't upload the backup of db.they have a db folder. I have to upload my db to that folder.But I don't know which file to upload in there.When I use 2 files (data and log) to load in there, it doesn't work.Thanks.The stupid question is the question you don't ask.www.single123.com |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-10-13 : 09:32:09
|
SQL isn't like Access, you can't just move the files around and it work. You need to copy both of the files up to the server. Then, you need to attach them to that server's SQL server. If you access through Enterprise Manager then you can right click on the server and choose to attach database. Select the data file when asked (.mdf).Corey |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-13 : 12:24:48
|
| Make sure you use the DETACH process (e.g. in Enterprise manager) BEFORE you copy the files up to the ISP. Once you've copied the files you can then re-ATTACH them to your local database (it is adviseable to take a backup before doing a DETACH just-in-case the database won't reattach for whatever reason)Kristen |
|
|
|
|
|
|
|
|
sql server db to upload _Data or _Log files HELP