In MS SQL 2005 mirroring, when the principal server fails you need to execute the following on the mirror server in order to make the mirror server active.
ALTER DATABASE [database name] SET PARTNER OFF
go
RESTORE DATABASE [database name] WITH RECOVERY
go
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment