Re: Migration

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rich (anonymous_at_discussions.microsoft.com)
Date: 08/28/04 

Date: Sat, 28 Aug 2004 16:27:10 -0700

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
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: NTBACKUP error
    ... Are you putting the oracle tablespaces in backup mode before doing the ... start of the backup which they will be doing if the database is ... Shutting down archive processes ... Undo Segment 1 Onlined ...
    (comp.databases.oracle.server)
  • Re: NTBACKUP error
    ... Are you putting the oracle tablespaces in backup mode before doing the ... start of the backup which they will be doing if the database is ... Shutting down archive processes ... Undo Segment 1 Onlined ...
    (comp.databases.oracle.server)