Re: Migration

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/29/04

  • Next message: Sam: "Methodology for swapping SQL 2000 servers?" 
    Date: Sat, 28 Aug 2004 20:07:54 -0400

    Glad to hear it went well. 

    -- 
Andrew J. Kelly  SQL MVP
"Rich" <anonymous@discussions.microsoft.com> wrote in message
news:203201c48d56$8a518a40$a501280a@phx.gbl...
> Hi Andrew,
>
> How many ways can I say "Thank you".  Everything worked
> really well.
>
> Thanks
> Rich
> >-----Original Message-----
> >The links I provided has lots of this information as
> does BooksOnLine.
> >Personally I prefer to use the backup command instead of
> the gui.  Here is a
> >simple example to issue a Full backup of a database to
> disk. Take a look at
> >BooksOnLine under "Backup" for more details.
> >
> >BACKUP YourDBName to Disk
> = 'D:\YourPath\YourFileName.bak' WITH INIT, STATS
> >= 10
> >
> >http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;304692
> >
> >-- 
> >Andrew J. Kelly  SQL MVP
> >
> >
> >"Rich" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:1fcd01c48d45$a9db7c10$a501280a@phx.gbl...
> >> Hi Andrew -
> >> Thanks for getting back to me. Please forgive my
> >> ignorance, how do I do a full backup?  When I
> >> select "backup" it only gives me databases, not the
> >> entire database.
> >> Thanks
> >> Rich
> >> >-----Original Message-----
> >> >Sounds like one of your db's has a user named MB but
> >> there is no associated
> >> >Login that exists.  Here are some links that you may
> >> want to check out but
> >> >if you want to move everything your best bet is
> usually
> >> just a simple Full
> >> >backup and restore.
> >> >
> >> >
> >> >http://www.support.microsoft.com/?id=314546     Moving
> >> DB's between Servers
> >> >http://www.support.microsoft.com/?id=224071     Moving
> >> SQL Server Databases
> >> >to a New Location with Detach/Attach
> >> >http://support.microsoft.com/?id=221465
> >> Using WITH MOVE in a
> >> >Restore
> >> >http://www.support.microsoft.com/?id=246133     How To
> >> Transfer Logins and
> >> >Passwords Between SQL Servers
> >> >http://www.support.microsoft.com/?id=298897    Mapping
> >> Logins & SIDs after a
> >> >Restore
> >> >http://www.dbmaint.com/SyncSqlLogins.asp
> Utility
> >> to map logins to
> >> >users
> >> >http://www.support.microsoft.com/?id=168001     User
> >> Logon and/or Permission
> >> >Errors After Restoring Dump
> >> >http://www.support.microsoft.com/?id=240872    How to
> >> Resolve Permission
> >> >Issues When a Database Is Moved Between SQL Servers
> >>
> >http://www.sqlservercentral.com/scripts/scriptdetails.asp
> >> ?scriptid=599
> >> >Restoring a .mdf
> >> >http://www.support.microsoft.com/?id=307775
> Disaster
> >> Recovery Articles
> >> >for SQL Server
> >> >
> >> >http://www.support.microsoft.com/?id=274463
> >> Copy DB Wizard issues
> >> >
> >> >
> >> >-- 
> >> >Andrew J. Kelly  SQL MVP
> >> >
> >> >
> >> >"Rich" <anonymous@discussions.microsoft.com> wrote in
> >> message
> >> >news:1f0301c48d16$1499fed0$a301280a@phx.gbl...
> >> >> Hi,
> >> >> I am in the process of creating a new server and
> want
> >> to
> >> >> copy an existing database from the old server to the
> >> new
> >> >> server. I can move the tables but I try to move all
> >> >> objects the transfer fails. I am getting following
> >> >> message "[Microsoft][ODBC SQL Server Driver][SQL
> >> Server]
> >> >> The login 'MB' does not exist."  What does that
> mean?
> >> is
> >> >> there a file that I am missing?
> >> >> Any help would be appreciated.
> >> >> Thanks
> >> >> Rich
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >
  • Next message: Sam: "Methodology for swapping SQL 2000 servers?"

    Relevant Pages

    • Re: Performance really poor if calling data from sql clients
      ... The power management is set to a mode that no power off for hard disk nor CPU ... Andrew J. Kelly SQL MVP ... profiler to see what is happening on the sql server end. ...
      (microsoft.public.sqlserver.clients)
    • Re: Server semi-shutdown
      ... Andrew - thanks for keeping me posted on this. ... much appreciated (particularly if cycling the realtime server service fixes ... >> shortcut to the command prompt, and it takes 20 minutes to open. ... >> immediately after the backup completes. ...
      (microsoft.public.windows.server.sbs)
    • Re: Performance really poor if calling data from sql clients
      ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the ... Server already restarted several times (MSSQLSERVER, ...
      (microsoft.public.sqlserver.clients)
    • Re: How to convert the SQL Developer Edition to SQL Standard Editi
      ... Andrew J. Kelly SQL MVP "Kam" wrote in message ... > I think i make this mistake when I try to install the sharepoint portal> server on that machine. ...
      (microsoft.public.sqlserver.setup)
    • Re: dbcc checkcatalog problem
      ... Andrew J. Kelly SQL MVP ... "Alexander Pfingstl" wrote in message ... > Then start the Server again. ... >> Andrew J. Kelly SQL MVP ...
      (microsoft.public.sqlserver.server)