Very Computer

by **Todd** » Fri, 21 Feb 2003 16:52:09

I am attempting to move a database from one box to another. I want to copy
all user accounts and passwords, etc. Is there a procedure for this?

by **Mark Broadben** » Fri, 21 Feb 2003 17:08:52

There are many different ways to do this, however the easiest (in my view)
would be to backup all seperate databases to a .bak file (backup device),
copy this file to new server and do a forced restore from this device over
the top of each db.

hope this helps,

Mark Broadbent mcse+i, mcdba

Quote:> I am attempting to move a database from one box to another. I want to copy
> all user accounts and passwords, etc. Is there a procedure for this?

by **Todd** » Fri, 21 Feb 2003 17:22:45

I did that, but my logins aren't working.

> There are many different ways to do this, however the easiest (in my view)
> would be to backup all seperate databases to a .bak file (backup device),
> copy this file to new server and do a forced restore from this device over
> the top of each db.

> hope this helps,

> Mark Broadbent mcse+i, mcdba

> > I am attempting to move a database from one box to another. I want to
copy
> > all user accounts and passwords, etc. Is there a procedure for this?

by **Tibor Karasz** » Fri, 21 Feb 2003 17:53:21

Did you read about sp_change_users_login in Books Online?

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...

> I did that, but my logins aren't working.

> > There are many different ways to do this, however the easiest (in my view)
> > would be to backup all seperate databases to a .bak file (backup device),
> > copy this file to new server and do a forced restore from this device over
> > the top of each db.

> > hope this helps,

> > Mark Broadbent mcse+i, mcdba

> > > I am attempting to move a database from one box to another. I want to
> copy
> > > all user accounts and passwords, etc. Is there a procedure for this?

by **Mark Broadben** » Fri, 21 Feb 2003 18:38:30

are you also backing up and overwriting the production master db (assuming
that the production server is new and currently has no data on
it) -otherwise use the method described by Tibor

--
BR,

Mark Broadbent mcse+i, mcdba

> I did that, but my logins aren't working.

> > There are many different ways to do this, however the easiest (in my
view)
> > would be to backup all seperate databases to a .bak file (backup
device),
> > copy this file to new server and do a forced restore from this device
over
> > the top of each db.

> > hope this helps,

> > Mark Broadbent mcse+i, mcdba

> > > I am attempting to move a database from one box to another. I want to
> copy
> > > all user accounts and passwords, etc. Is there a procedure for this?

by **Denn** » Sat, 22 Feb 2003 00:10:45

If SQL 2000 then create a DTS package and use the Transfer Logins object.

--
Denny Cherry
Database Administrator
GameSpy Industries

Quote:> I am attempting to move a database from one box to another. I want to copy
> all user accounts and passwords, etc. Is there a procedure for this?

by **Tibor Karasz** » Sat, 22 Feb 2003 09:29:44

Note that DTS does not keep the original SID for the SQL Server logins. I.e., for SQL Server
logins, you still have to do the sp_change_users_logins thing.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...

> If SQL 2000 then create a DTS package and use the Transfer Logins object.

> --
> Denny Cherry
> Database Administrator
> GameSpy Industries

> > I am attempting to move a database from one box to another. I want to copy
> > all user accounts and passwords, etc. Is there a procedure for this?

Very Computer

Moving a Database to a Devlopment Box

Moving a Database to a Devlopment Box

Moving a Database to a Devlopment Box

Moving a Database to a Devlopment Box

Moving a Database to a Devlopment Box

Moving a Database to a Devlopment Box

Moving a Database to a Devlopment Box

Moving a Database to a Devlopment Box