| Title: | Microsoft SQL Server Support |
| Notice: | Please Registar, Note #11 |
| Moderator: | AMCUCS::BETTS |
| Created: | Tue Aug 23 1994 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 382 |
| Total number of notes: | 1233 |
Hello,
I have a question about the new fallback procedures in SQL 6.5.
When I use the sp_fallback procedures to fail a database over to
another server, the database owner is always SA on the fallback server.
Is this the way it is supposed to work, or can you set it up to use the
original owner of the database.
thanks In advance...
Paul Brady
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 380.1 | CSC32::HOEPNER | A closed mouth gathers no feet | Wed May 28 1997 15:29 | 3 | |
Have you talked to the cluster folks?
| |||||
| 380.2 | CSC32::P_BRADY | Tue Jun 03 1997 13:22 | 5 | ||
Clusters is not the issue...
The question is why does SQL server use the SA account for the database
owner of a "failed over" server. I am perty sure this is just the way
it works, but I am trying to verfiy this...
| |||||
| 380.3 | That's how fallback works. | MSE1::MASTRANGELO | Wed Jun 04 1997 06:54 | 17 | |
Hi Paul,
This is from SQL Books Online...
"On the primary server, the DBO for a given database can be logged on to
a login other than SA. But when fallback is activated, each database is
installed with the DBO recorded as the SA. You can, however, execute
the necessary procedures to change the DBO of a database that is being
actively supported on the fallback server."
Do a query on "fallback" for more. There's quite a bit on fallback.
Rocco
| |||||