Mustafa EL-Masry SQl server Administration

How to transfer Login and password from Server to Server in MSSQL 2008


Problem :

When you install new instance SQL Server in New Server you won’t to Copy all users from Server A to the New Server B so let’s se the solution

Solution :

Microsoft make good solution about this problem  Check this link : http://support.microsoft.com/kb/918992

 

Microsoft make Script to run it on old server to generate Script for your all Users and passwords then take this Script and run it on your new server

 

Mustafa EL-Masry Mirroring SQL Server 2008

Error When make Mirroring between SQL Server Standard Edition and Enterprise Edition


we can have Mirroring between Standard and Enterprise editions. But when you do this via SSMS (Graphical Interface), you might end up with following error message.

But when we use T-SQL statements, we were able to setup database mirroring and which worked perfectly fine too.

Error Message:

This mirroring configuration is not supported. Because the principal server instance, <server_name>, is Standard Edition, the mirror server instance must also be Standard Edition.

531x484xSQLServerMirroringEditionError_thumb_jpg_pagespeed_ic_yWV4PufZF4

Mustafa EL-Masry Windows Server 2008 R2

BgInfo v4.16


If you manage multiple computers you probably need BGInfo. It automatically displays relevant information about a Windows computer on the desktop’s background

Download BgInfo software

http://technet.microsoft.com/en-us/sysinternals/bb897557