Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


moving databases,logins


moving databases,logins

Author
Message
srimkumarp
srimkumarp
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 108
hi, how to move databases from old server 2005 to new server 2005 and also logins.if we moved databases and logins from old server.will it contain database ,logins or not?
martin-210793
martin-210793
Old Hand
Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)

Group: General Forum Members
Points: 341 Visits: 300
Logins are stored in the master database,
thus you can move your database but the logins wont be moved over. the DB usernames will be though. Using these you can relink the usernames and create logins. Use inbuilt stored procedure - I can't remember the name of it. Books online should give you these.
Tommy Bollhofer
Tommy Bollhofer
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1302 Visits: 3359
Refer to KB 246133 (http://support.microsoft.com/kb/246133/)

Tommy

Follow @sqlscribe
SQL_ABD
SQL_ABD
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1372 Visits: 1349
Hi,
Check also the following http://blogs.techrepublic.com.com/howdoi/?p=140
Regards,
Ahmed
Menaka-441717
Menaka-441717
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 24
Hi There,

from the source server bcp out..syslogins and copy to the target server using bcp in command.Hope it will resolve your login issue.

Cheers
Menaka
Sugesh Kumar
Sugesh Kumar
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3633 Visits: 358
Databases can be moved using the detach and attach method. For logins there is a script in MICROSOFT site that will script your logins with password. you can use that.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Minaz Amin
Minaz Amin
Say Hey Kid
Say Hey Kid (708 reputation)Say Hey Kid (708 reputation)Say Hey Kid (708 reputation)Say Hey Kid (708 reputation)Say Hey Kid (708 reputation)Say Hey Kid (708 reputation)Say Hey Kid (708 reputation)Say Hey Kid (708 reputation)

Group: General Forum Members
Points: 708 Visits: 1750
We have done the same that sugesh suggested.

"More Green More Oxygen !! Plant a tree today"
Bill Prehl
Bill Prehl
SSC Journeyman
SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)

Group: General Forum Members
Points: 93 Visits: 98
Since I found this thread on this topic, it should be noted that MS has two KB's regarding moving login accounts between SQL servers.

One KB is for moving logins between SQL7 to SQL2k or SQL2k to SQL2k
http://support.microsoft.com/kb/246133/

The other is for moving logins between SQL 2k5/8 to 2k5/8
http://support.microsoft.com/kb/918992/

The reason for the differences is because they changed some of there sysobject schema.

Cheers.

Bill
vijju.gaddam488
vijju.gaddam488
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 213
we've big script you execute that in primary server that creates two stored procedures in master database 1.sp_hexadecimal
2.sp_revlogin

if you execute first one it give one more script for us you execute that one (result script)in secondary then you can transfer dbs.in the same way if you execute sp_revlogin you can transfer logins also.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search