mirror from cluster

I am wondering if you can do mirroring in sql server 2005 from an
active/passive server cluster. We have a 2 node active/passive server
cluster operating that has 3 sql server 2005 databases on it. We are
wanting to mirror those databases to another server so query's can be
run against the mirrored copy instead of the production cluster. Will
mirroring function in the configuration. ThanksDatabase Mirroring is orthogonal to failover clustering. So the answer is yes
you can do database mirroring from a cluster.
Linchi
"mmark751969" wrote:
> I am wondering if you can do mirroring in sql server 2005 from an
> active/passive server cluster. We have a 2 node active/passive server
> cluster operating that has 3 sql server 2005 databases on it. We are
> wanting to mirror those databases to another server so query's can be
> run against the mirrored copy instead of the production cluster. Will
> mirroring function in the configuration. Thanks
>

Mining Content Viewer for Linear Regression: Node Distribution output

With the number of threads it is difficult to know if this has been posted. If I use the Mining Content Viewer for Linear Regression, under Node Distribution, there are values given for Attribute Name, Attribute Value, Support, Probability, Variance, and Value Type. The output is similar to what Joris supplied in his thread about Predict Probability in Decision Trees. My questions:

1. How should these fields be interpreted?

2. With Linear Regression, is it possible to get the coefficient values and tests of significance (t-tests?), if they are not part of the output I have pointed to?

Thanks for your help with this?

Sam

The interpretation of the NODE_DISTRIBUTION rows depends mainly on the VALUE TYPE column.

To exemplify the values, here is the distribution of one node from applying regression to the Iris data set. The target is PetalWidth, with SepalLength, SepalWidth and PetalLength as regressors:

- Two rows of the distribution describe the target continuous attribute. They can be recognized by their value type. The row having value type 1 (Missing) represents the statistics for the Missing state of the target attribute in the current node, while the row having value type 3 (Continuous) represents the statistics for the Existing state of the target attribute. If you do not have gaps in your data, than you can ignore the row with ValueType = 1. For the row with value type 3, ATTRIBUTE_NAME is the name of the target attribute (PetalWidth in my example), ATTRIBUTE_VALUE is the mean of the PetalWidth. You also get the support and variance. Support is the number of training casese in this node, Mean and Variance are computed only over the traiing cases that ended up in this node

- For each regressor, there are 3 distribution rows, having the valuetype, respectively: 7(coefficient), 8(Score gain), 9(Statistics). For all these 3 rows, ATTRIBUTE_NAME is the name of the regressor. Then:

for the row with Value Type 7 (Coefficient), ATTRIBUTE_VALUE is the regression coefficient associated with the regressor ('a' in y=ax+b).

Migration ?

Hello,
I currently have a SQL 2000 SP3 STD running in my org, I want to move it's
contents to a clustered (two node) system running SQL 2005 STD edition. Is
it possible to move the entire contents of my old SQL environment to the new
environment? I would like to preserve user logins and the current instance
name of my old server. I know it might require me renaming the old SQL
server name when I get to that point. If someone could give me some tips on
how (or if it's even possible) to do this I would be highly greatful.
Thank you
Alex Anderson
You have to move the databases to the new server individually. Most of
these were written for 2000 but still apply to 2005.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/colu...rdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scri...tions/1598.asp Script
Roles and Permissions
Andrew J. Kelly SQL MVP
"Alex Anderson" <AlexAnderson@.discussions.microsoft.com> wrote in message
news:2DF0B36D-5B38-4BE1-A448-91CE4F33F5B2@.microsoft.com...
> Hello,
> I currently have a SQL 2000 SP3 STD running in my org, I want to move it's
> contents to a clustered (two node) system running SQL 2005 STD edition.
> Is
> it possible to move the entire contents of my old SQL environment to the
> new
> environment? I would like to preserve user logins and the current
> instance
> name of my old server. I know it might require me renaming the old SQL
> server name when I get to that point. If someone could give me some tips
> on
> how (or if it's even possible) to do this I would be highly greatful.
> Thank you
> Alex Anderson
>
|||Actually, it can be done a bit more simply than that. You need to do the
following:
1. Configure the cluster
2. Install a SQL Server failover cluster instance
3. Backup the master database on your standalone and restore it to the
failover cluster instance
4. Backup msdb and restore it to the failover cluster instance
5. Move your databases using either a detach/attach or backup/restore
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:et0zGJSVGHA.6084@.TK2MSFTNGP14.phx.gbl...
> You have to move the databases to the new server individually. Most of
> these were written for 2000 but still apply to 2005.
> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx
> Moving system dbs 2005
> http://www.databasejournal.com/featu...le.php/3379901
> Moving system DB's 2000
> http://www.support.microsoft.com/?id=314546 Moving DB's between
> Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server
> Databases to a New Location with Detach/Attach
> http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.sqlservercentral.com/colu...rdatabases.asp
> Moving Users
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs
> after a Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or
> Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scri...p?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
> http://www.support.microsoft.com/?id=320125 Moving a Diagram
> http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
> http://www.sqlservercentral.com/scri...tions/1598.asp Script
> Roles and Permissions
> --
> Andrew J. Kelly SQL MVP
>
> "Alex Anderson" <AlexAnderson@.discussions.microsoft.com> wrote in message
> news:2DF0B36D-5B38-4BE1-A448-91CE4F33F5B2@.microsoft.com...
>
|||Michael,
Moving the Master and MSDB database, what if the old server where those
databases are coming from are different builds? Will a restore on the SQL
2005 cluster allow this?
Thank you
Alex Anderson
"Michael Hotek" wrote:

> Actually, it can be done a bit more simply than that. You need to do the
> following:
> 1. Configure the cluster
> 2. Install a SQL Server failover cluster instance
> 3. Backup the master database on your standalone and restore it to the
> failover cluster instance
> 4. Backup msdb and restore it to the failover cluster instance
> 5. Move your databases using either a detach/attach or backup/restore
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:et0zGJSVGHA.6084@.TK2MSFTNGP14.phx.gbl...
>
>
|||During a restore, all of the metadata is upgraded. So, yes, it does work.
You will obviously want to test it before doing it in production.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Alex Anderson" <AlexAnderson@.discussions.microsoft.com> wrote in message
news:0A3A75CF-166A-4BD7-88C9-1B55B519B9B7@.microsoft.com...[vbcol=seagreen]
> Michael,
> Moving the Master and MSDB database, what if the old server where those
> databases are coming from are different builds? Will a restore on the SQL
> 2005 cluster allow this?
> Thank you
> Alex Anderson
>
> "Michael Hotek" wrote:
|||Michael,
I've tried every way I can think of trying to restore the master database.
I fail every time because it's complaining about the build numbers being
different. Is there something I can need to check to override this?
Thank you
Alex Anderson
"Michael Hotek" wrote:

> During a restore, all of the metadata is upgraded. So, yes, it does work.
> You will obviously want to test it before doing it in production.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Alex Anderson" <AlexAnderson@.discussions.microsoft.com> wrote in message
> news:0A3A75CF-166A-4BD7-88C9-1B55B519B9B7@.microsoft.com...
>
>