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 |
|
QBALL
Starting Member
9 Posts |
 Posted - 2008-10-28 : 18:50:35
|
| HiI'm trying to upload to an SQL database using the DTS wizard tool. On the first dialog box it asks you for the server, my MDF I want to upload is under mycomputersname\SQLEXPRESS but unfortunately it does not show up in the database list. Does anyone know how I can add it to the list please.I've been trying to sort this out for three days now and I'm starting to loose the will to live.ThanksRob |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-10-29 : 07:22:08
|
| What do you mean when you say you are trying to 'upload' the .mdf?If you want to attach the database, then use sp_attach, if you just want to view it in EM then register the server.If you want to import the database, then use the import database wizard. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-29 : 07:37:25
|
quote:
Originally posted by QBALL
I've been trying to sort this out for three days now and I'm starting to loose the will to live.
Awwwwgh  Have a  |
|
|
|
QBALL
Starting Member
9 Posts |
Posted - 2008-10-31 : 07:00:31
|
| Thanks for the quick replies,I tried to attach the db using sp_attach but I kept getting errors! I tried using the import Wizard but in the drop down box for database my db was not listed.The site had to go live so I hooked onto the remote sql and rebuilt the tables and added the data by hand. Fortunately it was a small project, but I need to sort this out for future sites.Thanks |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-31 : 07:04:46
|
| what version are u using. also do you have a backup ? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-10-31 : 09:55:47
|
| I am guessing you did not have a .LDF to go with it and this is why you were getting errors? If so, you could have used sp_attach_single_file_db. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-10-31 : 10:40:19
|
| QBALL -- 1) never just say "things don't work" or "you get errors" -- be specific! How can we help you without all the details? If you can an error message, read it carefully and if that doesn't help, post the entire message when asking for help in forums.2) if you want to attach an MDF file to a database, you must upload it so that it is stored locally on the SQL Server you want to attach it to. Attaching an MDF doesn't do any sort of "upload and copy", it just hooks up SQL Server to an existing MDF file that lives on the server.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
QBALL
Starting Member
9 Posts |
Posted - 2008-11-04 : 05:24:49
|
| The erroe message I received whilst trying to attach the MDF file was"Error 602: could not find row in sysindexes for database ID5, Object ID1. Run DBCC checktable on sysindexes"Yes I have an LDF file to go with the MDF file.I was trying to attach my MDF file file to the local server by: 1) local server2) Right click on databases3) All tasks4) Attach databaseIs this the wrong way to go about this? |
|
|
|
|
|
|
|
|
SERVER ENTERPRISE MANAGER