Microsoft KB Archive/153728

= INF: Additional Fallback Considerations =

Article ID: 153728

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q153728



SUMMARY
Fallback is a new feature of SQL Server 6.5 which enables machine fault tolerance for a user database by using a shared drive. For more information, see the following topic in Books Online:

What's New in SQL Server 6.5\Part 3 What's New for Administrators\ Fallback Support.



MORE INFORMATION
Here is a list of general steps to set up a fallback server before taking the steps listed in Books Online. Note that some of the steps are suggested to create a transparent change to the fallback server.

 Acquire any specialized hardware as defined in Books Online Install the same network protocols on the fallback server as are on the primary computer (as listed in Control Panel\Network). Choose the same domain for the fallback server as for the primary computer and place the fallback server on the same physical LAN segment. Install SQL Server on the fallback server, making sure of the following:

 That the drive where you're installing SQL Server is not the shared drive That the Net-Libraries listed on the fallback server are the same as on the primary machine That the code page (character set) and sort order are the same as on the primary computer</li> That the sp_configure option "user connections" are set the same as the primary computer</li> That licensing is set up with the same mode as the primary computer, and that the number of licenses for Per Server mode is the same as the primary machine. Note that this is legal since only one of the servers will use the licenses at a time.</li></ol> </li> Create SQL Server logons to match the primary computer. The following script will create a script of logons with the following exceptions:

<ol style="list-style-type: lower-alpha;"> The passwords are null and need to be corrected by the user</li>  The default database can not be the same as one of the fallback databases

SELECT "exec sp_addlogin " + name + ",NULL," + dbname + "," + isnull(language,'NULL') + "," + convert(char(6),suid) FROM syslogins WHERE name NOT IN ('sa','probe','repl_publisher','repl_subscriber')

In order to correct the default database, run the following script to generate a script. Run the result script after the fallback server has taken over the database:

SELECT "exec sp_defaultdb " + name + ","+ dbname FROM syslogins WHERE name NOT IN ('sa','probe','repl_publisher','repl_subscriber') </li></ol> </li> If the primary server is using Integrated or Mixed security, perform the following steps:

<ol style="list-style-type: lower-alpha;"> Create the same local groups on the fallback server as the primary server using the User Manager for Domains application</li>  Create logon permissions on the fallback server with SQL Security Manager or use the following script to create a script of the logon permissions:

CREATE TABLE #groups (accountname    char(255) not null,       grouptype       char(20)  null,       privilege       char(5)   not null,       mappedloginname char(255) null,       permissionpath  char(255) null) insert #groups exec xp_logininfo select "exec xp_grantlogin '" + rtrim(accountname) + "','" + rtrim(privilege) + "'" from #groups </li></ol> </li> Test client connectivity by connecting directly to the fallback server.</li> If you use Remote Stored Procedure calls, then the remote servers and remote logons should also be set up on the fallback server.</li></ol>

Additionally, the following features of SQL Server may require additional work to handle fallback support:


 * 1) Replication
 * 2) Scheduled tasks
 * 3) Alerts
 * 4) SQLMail

Additional query words: Setup sp_fallback fail over hot backup

Keywords: KB153728

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.