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 |
|
tpk
Starting Member
10 Posts |
 Posted - 2003-03-28 : 17:50:13
|
| My web host does not give me access to my MDF and LDF files. Is there a way around this anyone can suggest? I'm looking for an alternative to DTS and copying objects.Edited by - tpk on 03/28/2003 17:50:46 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-28 : 17:54:53
|
| Why would you need access to the MDF and LDF files? There isn't anything you can do with them while the service is started. And what do you mean doesn't give you access to MDF and LDF files? What is it that you want to do with those files? If you just want access to the objects, then script them out and then copy the data using bcp or DTS OR if you want an exact copy of the database and can't do a detach, then just do a backup and a restore.Do you have access to the database through any tools such as Enterprise Manager or Query Analyzer? If so, then you can do anything that you want provided you have sa or dbo (less powerful than sa) privileges.Please explain more.Tara |
 |
|
|
tpk
Starting Member
10 Posts |
Posted - 2003-03-28 : 18:08:13
|
| Yes I have access with Enterprise Manager and Query Analyzer. I want to be able to transfer, backup and restore my databases quickly (or at a later date) to different servers. This is in my opinion best done by just moving the MDF and LDF files rather than for example, using DTS and copying all objects. As my hosts don't give access to the files directly, it looks like I'm forced to use DTS to backup my databases, which isn't a very good option.Edited by - tpk on 03/28/2003 18:08:58 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-28 : 18:27:32
|
| You don't have to use DTS to move your databases. Just use BACKUP/RESTORE method. To copy the files, use xp_cmdshell, which is assuming you have access to xp_cmdshell. If you don't have access to xp_cmdshell, then you are going to have to use DTS, Copy database wizard, or bcp (I recommend bcp if you are familiar with it).Tara |
|
|
|
tpk
Starting Member
10 Posts |
Posted - 2003-03-28 : 20:45:33
|
| Thanks tduggan. I realise I don't have to use DTS, but in this instance, it looks like I might as even the backup/restore feature has been disabled by my web host. They've also (understandably) removed access to xp_cmdshell. I'm assuming I have to make do with DTS (copy all objects) or script the tables/sprocs and bcp the data. I was sort of hoping I could somehow use Query Analyzer to just move the db files (without too much code) to somewhere I could get at them for backup purposes, but that doesn't look possible. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-28 : 21:06:37
|
| You could also maybe use dmo to transfer the objects - easier than dts.There's an example on www.nigelrivett.com under dmo.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
BCP transfer MDF and LDF files?