Restoring SQL 2000 Database from Cluster Config to Standalone

Hi
I have a tech question relating to SQL 2000
If I had a 2 node cluster of SQL , are there any implications/restrictions
in restoring the Database to another Domain / Server which is a SINGLE non
clustered server?
Many thanks!The database knows nothing of if it is or ever was in a clustered server or
not. So the answer is that there should be no problems related to the fact
it was in a clustered server when the backup was taken.
--
Andrew J. Kelly SQL MVP
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
> Hi
> I have a tech question relating to SQL 2000
> If I had a 2 node cluster of SQL , are there any implications/restrictions
> in restoring the Database to another Domain / Server which is a SINGLE non
> clustered server?
> Many thanks!|||So the domain also will not matter?...SQL will function if I was to restore
it on a Server that was in another WOrkgroup and not even a domain; like the
original?
"Andrew J. Kelly" wrote:
> The database knows nothing of if it is or ever was in a clustered server or
> not. So the answer is that there should be no problems related to the fact
> it was in a clustered server when the backup was taken.
> --
> Andrew J. Kelly SQL MVP
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
> > Hi
> >
> > I have a tech question relating to SQL 2000
> >
> > If I had a 2 node cluster of SQL , are there any implications/restrictions
> > in restoring the Database to another Domain / Server which is a SINGLE non
> > clustered server?
> >
> > Many thanks!
>
>|||Again the database itself knows nothing of these things. The SQL Server
instance that you restore the db to has to deal with the OS and such. I
assume you already have that working since all you asked about was restoring
a db to another server. You may have to deal with a Login to db User
mismatch depending on the conditions but that may be true even if you
restored it on the same server. See if these help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's
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://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.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/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...
> So the domain also will not matter?...SQL will function if I was to
> restore
> it on a Server that was in another WOrkgroup and not even a domain; like
> the
> original?
> "Andrew J. Kelly" wrote:
>> The database knows nothing of if it is or ever was in a clustered server
>> or
>> not. So the answer is that there should be no problems related to the
>> fact
>> it was in a clustered server when the backup was taken.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Jay" <Jay@.discussions.microsoft.com> wrote in message
>> news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
>> > Hi
>> >
>> > I have a tech question relating to SQL 2000
>> >
>> > If I had a 2 node cluster of SQL , are there any
>> > implications/restrictions
>> > in restoring the Database to another Domain / Server which is a SINGLE
>> > non
>> > clustered server?
>> >
>> > Many thanks!
>>|||Many thanks Andrew! Appreciate the response!
"Andrew J. Kelly" wrote:
> Again the database itself knows nothing of these things. The SQL Server
> instance that you restore the db to has to deal with the OS and such. I
> assume you already have that working since all you asked about was restoring
> a db to another server. You may have to deal with a Login to db User
> mismatch depending on the conditions but that may be true even if you
> restored it on the same server. See if these help:
>
> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
> system DB's
> 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://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.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/scripts/scriptdetails.asp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly SQL MVP
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...
> > So the domain also will not matter?...SQL will function if I was to
> > restore
> > it on a Server that was in another WOrkgroup and not even a domain; like
> > the
> > original?
> >
> > "Andrew J. Kelly" wrote:
> >
> >> The database knows nothing of if it is or ever was in a clustered server
> >> or
> >> not. So the answer is that there should be no problems related to the
> >> fact
> >> it was in a clustered server when the backup was taken.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> >> news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
> >> > Hi
> >> >
> >> > I have a tech question relating to SQL 2000
> >> >
> >> > If I had a 2 node cluster of SQL , are there any
> >> > implications/restrictions
> >> > in restoring the Database to another Domain / Server which is a SINGLE
> >> > non
> >> > clustered server?
> >> >
> >> > Many thanks!
> >>
> >>
> >>
>
>