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 |
|
badua
Starting Member
8 Posts |
 Posted - 2004-06-22 : 00:10:26
|
| Hi all you,I have a problem that when I want to backup my database located on a remote SQL server, I use Copy objects and data in DTS Import/Export Wizard, but when gain about 94%, a failure message appears: login "user" does not exist.Following a suggest, I don't select Copy SQL server logins in Options but still not success. Give me a help, please! Thanks in advance, |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-06-22 : 00:34:22
|
| Is there any special reason why you're using DTS?It is much easier to back up your database by using the BACKUP DATABASE statement. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-22 : 00:50:35
|
| Sounds like there is a remote object "Owned" by a specific user that does not exist on the local installation.Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-22 : 07:45:09
|
| Look up sp_help_revlogin on the forums (search). This will solve your issue.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Backup a remote database, help me!