Re: Problem transferring data and objects

Wie heißt 'BACKUP AND RESTORE' auf deutsch?

Es is sehr schwer in einer andere Sprache zu arbeiten :)

"Allan Mitchell" wrote:

> Warum benutzen Sie nicht BACKUP/RESTORE? Es ist mehr einfach und fehlerfrei.
>
> Why are you not using BACKUP and RESTORE. It is asimple and error free.
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - SQL Server 2005 Integration Services.
> www.Konesans.com
>
>
> "rufus" <rufus@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:4E0EE6B6-994E-4C16-98DE-F8BFC6C03CA2@xxxxxxxxxxxxxxxx
> >I will preface this by saying I am a beginner. I want to export the contents
> > of a local database to a remote server. On the remote server I create an
> > empty database of the same name and then try and import the data and objects.
> > I keep getting an error "Der benutzername 'preisr_admin' ist nicht
> > vorhanden' which means something like 'The username 'preis_admin' does not
> > exist'. Any ideas as to what the problem might be and how I can solve it?
> >
> > I have also tried making a dump (backup?) of the database into a .dmp file
> > and importing the file. It works but does not import any of my objects such
> > as tables and stored procedures (only the default system objects). I have
> > tried all the dump options but nothing seems to allow me to include objects
> > in my dump. Any ideas?
> >
> > Are there any other reliable ways of importing a database from one server to
> > another?
> >
> > Thanks in advance.
>
>
>
.

Relevant Pages

  • Re: SQL Backup and Restore
    ... You could create a job on your remote server that issues the restore ... When the backup job on the primary server is complete you can add ...
    (microsoft.public.sqlserver.server)
  • RE: Copy Database Wizard
    ... Does the Backup and Restore take all of the logins, jobs, etc ... "Allan Mitchell" wrote: ... > Even though you have a few dbs to back up I would still be using BACKUP RESTORE ...
    (microsoft.public.sqlserver.dts)
  • SQL Backup and Restore
    ... I would like to backup my SQL db every night copy to a remote server and ... automate the restore. ... I currently have an automated backup copied to the ...
    (microsoft.public.sqlserver.server)
  • Restoring to alternative secondary server
    ... I've tried a couple of times to use the SPS Backup & Restore program to ... backup and restore a portal from one server to another. ... course succeeds but when I try to restore on the remote server, ...
    (microsoft.public.sharepoint.portalserver)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)