Re: Upgrading Hardware, how best to move?

From: Ron Weldy (ronweldy@msn.com)
Date: 04/01/03 

From: "Ron Weldy" <ronweldy@msn.com>
Date: Mon, 31 Mar 2003 19:03:14 -0800

The KB articles did the trick! Thanks!

- Ron

"Ron Weldy" <ronweldy@msn.com> wrote in message
news:Oxz5$ZD9CHA.2284@TK2MSFTNGP12.phx.gbl...
> I am upgrading my SQL box to a new machine and have been experimenting
with
> backup and restore to move my databases. This method does not seem to
bring
> over all the users and security settings. Is there a way to script or
> otherwise move all the settings and preserve them? Do I have to backup and
> restore the master database?
>
>

Relevant Pages

  • Re: Restore to new hard drive with fresh Vista intall
    ... the security settings have changed from the original installation. ... When I use the back-up and restore feature I get messages ... When I do an "advanced restore" and choose "files from a backup made on ...
    (microsoft.public.windows.vista.general)
  • Re: restoring sql with VBscrip
    ... I found everything for backup and no topics, ... I have used VBScript program similar to below to restore. ... ' VBScript Program to restore the MyDatabase database from a specified ... ' Specify connection string to Master Database on SQL server. ...
    (microsoft.public.windows.server.scripting)
  • Re: Single user mode
    ... > but when i do that, i got an error message - Restore Database must be ... > used in single user mode when try to restore the master database. ... "Restoring the master Database from a Current Backup" ...
    (microsoft.public.sqlserver.server)
  • RE: Skipped Files
    ... log at first, secedit.sdb is a database of your security settings, tmp.edb is ... replay them in a restore... ... Symantec by default will not backup files that are open, ...
    (microsoft.public.windows.server.general)
  • Upgrading Hardware, how best to move?
    ... backup and restore to move my databases. ... over all the users and security settings. ...
    (microsoft.public.sqlserver.security)