Re: SQL User Backup
From: Adam Feind (adam_at_hot.rr.com)
Date: 02/13/04
- Next message: Jeff Price: "Re: Application Role & 2nd Database"
- Previous message: Andrew J. Kelly: "Re: SQL User Backup"
- In reply to: Andrew J. Kelly: "Re: SQL User Backup"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 13 Feb 2004 14:38:38 GMT
Andrew,
Thanks for all of the links! This will help me out a lot.
Adam
"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:euwnIrj8DHA.2460@TK2MSFTNGP09.phx.gbl...
> Here is a whole slew of related links:
>
>
> 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 Server MVP
>
>
> "theweapon" <theweapon@somewhere.usa> wrote in message
> news:tkYWb.9673$vz1.8311@fe2.texas.rr.com...
> > I have a SQL server that is having HDD problems. I can still access my
> > databases and I have backed them up and successfully restored the
database
> > accounts on a new SQL server; however I cannot figure out how to backup
> and
> > restore the user accounts. We have a database that was created by
someone
> > with specific SQL user accounts. Can I move those from the SQL server
> that
> > is having problems (they still work) to another server.
> >
> > Thanks in advance.
> >
> >
> >
>
>
- Next message: Jeff Price: "Re: Application Role & 2nd Database"
- Previous message: Andrew J. Kelly: "Re: SQL User Backup"
- In reply to: Andrew J. Kelly: "Re: SQL User Backup"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
