Moving a SQL Server 2005 Cluster from one Domain to another

First, Can you move a SQL Server 2005 Cluster from one active directory domain to another? If so, what are the steps in moving a SQL Server 2005 Cluster from one domain to another?

Are there any concerns in attempting that move? I know that the domain groups are a hard dependency and that you cannot change them without doing a full reinstall. Does this have any bearing to moving a cluster between domains?

Thank you in advance for you assistance.

David P

Hey David...did you review the following 2 kb articles, they lay the process and possible pitfalls out pretty well:

How to move a Windows Cluster Server from one domain to another

http://support.microsoft.com/kb/269196/

How to change domains for a SQL Server 2000 or SQL Server 2005 failover cluster

http://support.microsoft.com/default.aspx/kb/319016/en-us#appliesto

If you review and have further questions, just post back.

HTH

Moving a SQL 2000 Database

What are the steps I need to take to move a SQL 2000
database from one physical drive to another on the same
machine?Look up sp_detatch_db and sp_attach_db in BOL... Or use All Tasks -> Detach
Database and All Tasks -> Attach Database in Enterprise Manager.
You'll basically just need to detach the database files, move them, then
re-attach them. Generally a fairly painless process... YMMV, so back up
first if possible!
"jeffs" <jeffs@.bumbleandbumble.com> wrote in message
news:02ef01c3a3cd$72a7d250$a301280a@.phx.gbl...
> What are the steps I need to take to move a SQL 2000
> database from one physical drive to another on the same
> machine?|||In addition to Adam's post:
Check out KB 224071.
--
Tibor Karaszi
"jeffs" <jeffs@.bumbleandbumble.com> wrote in message
news:02ef01c3a3cd$72a7d250$a301280a@.phx.gbl...
> What are the steps I need to take to move a SQL 2000
> database from one physical drive to another on the same
> machine?|||Have a look at KB article Q224071
--
RajiA
"jeffs" <jeffs@.bumbleandbumble.com> wrote in message
news:02ef01c3a3cd$72a7d250$a301280a@.phx.gbl...
> What are the steps I need to take to move a SQL 2000
> database from one physical drive to another on the same
> machine?

Move Web Services Front-End

Does anyone know the steps to move the SQL RS web services front-end? The
back-end database will stay in its current location.
Thanks,
DougTake a look at this article:
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
--
erik perez
www.solien.com
"Doug Lott" <dlott@.rmahomeservices.com> wrote in message
news:OMDdED0lEHA.712@.TK2MSFTNGP09.phx.gbl...
> Does anyone know the steps to move the SQL RS web services front-end? The
> back-end database will stay in its current location.
> Thanks,
> Doug
>|||This article does a great of explaining how to move the web service to
another website on the same server, but I need to move the whole front-end
installation including the windows service to another server entirely.
Thanks,
Doug
"erik perez" <erik.nojunkmail.at.solien.com> wrote in message
news:eTO52F0lEHA.1672@.TK2MSFTNGP14.phx.gbl...
> Take a look at this article:
> http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> --
> erik perez
> www.solien.com
> "Doug Lott" <dlott@.rmahomeservices.com> wrote in message
> news:OMDdED0lEHA.712@.TK2MSFTNGP09.phx.gbl...
> > Does anyone know the steps to move the SQL RS web services front-end?
The
> > back-end database will stay in its current location.
> >
> > Thanks,
> >
> > Doug
> >
> >
>|||I would imagine it would probably be best to use the RS Installer to install
Reporting Services on the new server just like you installed the original
server. Make sure you backup your ReportServer and ReportServerTempDB
databases, and also make copies of your configuration files and encryption
key in case you need them. Also, you should note that installing Reporting
Services on a server separate from where the SQL Server database resides
will require you have an additional SQL Server license.
--
erik perez
www.solien.com
"Doug Lott" <dlott@.rmahomeservices.com> wrote in message
news:eY4GMQ0lEHA.3544@.TK2MSFTNGP15.phx.gbl...
> This article does a great of explaining how to move the web service to
> another website on the same server, but I need to move the whole front-end
> installation including the windows service to another server entirely.
> Thanks,
> Doug
> "erik perez" <erik.nojunkmail.at.solien.com> wrote in message
> news:eTO52F0lEHA.1672@.TK2MSFTNGP14.phx.gbl...
> > Take a look at this article:
> >
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> >
> > --
> > erik perez
> > www.solien.com
> >
> > "Doug Lott" <dlott@.rmahomeservices.com> wrote in message
> > news:OMDdED0lEHA.712@.TK2MSFTNGP09.phx.gbl...
> > > Does anyone know the steps to move the SQL RS web services front-end?
> The
> > > back-end database will stay in its current location.
> > >
> > > Thanks,
> > >
> > > Doug
> > >
> > >
> >
> >
>|||Erik is correct. This is the easiest way to move the report server. Trying
to do it manually is possible but not trivial. The biggest gotcha would be
if you point to the existing database during setup. If you are planning on
doing this then setup will think you are joining a web farm, as long as the
original machine is still running then everything should be fine, if it is
not then you will fail to activate. The other option is to install the new
RS pointing to a new DB. Once the install is complete use RSConfig.exe to
point to the old database. You will also need to run rskeymgmt to extract
the key from the old RS and import it into the new RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"erik perez" <erik.nojunkmail.at.solien.com> wrote in message
news:eOdHdZ0lEHA.1652@.TK2MSFTNGP09.phx.gbl...
> I would imagine it would probably be best to use the RS Installer to
install
> Reporting Services on the new server just like you installed the original
> server. Make sure you backup your ReportServer and ReportServerTempDB
> databases, and also make copies of your configuration files and encryption
> key in case you need them. Also, you should note that installing
Reporting
> Services on a server separate from where the SQL Server database resides
> will require you have an additional SQL Server license.
> --
> erik perez
> www.solien.com
> "Doug Lott" <dlott@.rmahomeservices.com> wrote in message
> news:eY4GMQ0lEHA.3544@.TK2MSFTNGP15.phx.gbl...
> > This article does a great of explaining how to move the web service to
> > another website on the same server, but I need to move the whole
front-end
> > installation including the windows service to another server entirely.
> >
> > Thanks,
> >
> > Doug
> >
> > "erik perez" <erik.nojunkmail.at.solien.com> wrote in message
> > news:eTO52F0lEHA.1672@.TK2MSFTNGP14.phx.gbl...
> > > Take a look at this article:
> > >
> http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> > >
> > > --
> > > erik perez
> > > www.solien.com
> > >
> > > "Doug Lott" <dlott@.rmahomeservices.com> wrote in message
> > > news:OMDdED0lEHA.712@.TK2MSFTNGP09.phx.gbl...
> > > > Does anyone know the steps to move the SQL RS web services
front-end?
> > The
> > > > back-end database will stay in its current location.
> > > >
> > > > Thanks,
> > > >
> > > > Doug
> > > >
> > > >
> > >
> > >
> >
> >
>

Move TempDB from F: to J: drive

I would like to move my server TempDB file from F: to J:
drive. What are the steps to complete this tasks?
Thank You,
TimSee "Moving Tempdb" in this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
--
David Portas
SQL Server MVP
--|||Hi,
USE master
go
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME ='J:\tempdb.mdf')
go
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME ='J:\templog.ldf')
go
where NAME refers to the logical name of the tempdb database and
log files, and where FILENAME refers to the new location of the
tempdb files. Once this command has run, you must restart the
mssqlserver service before it takes affect.
Thanks
Hari
MCDBA
"Tim" <anonymous@.discussions.microsoft.com> wrote in message
news:116c201c3f4ac$1e7d8280$a501280a@.phx.gbl...
>
> I would like to move my server TempDB file from F: to J:
> drive. What are the steps to complete this tasks?
> Thank You,
> Timsql

Move TempDB from F: to J: drive

I would like to move my server TempDB file from F: to J:
drive. What are the steps to complete this tasks?
Thank You,
TimSee "Moving Tempdb" in this article:
http://support.microsoft.com/defaul...kb;en-us;224071
David Portas
SQL Server MVP
--|||Hi,
USE master
go
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME =
'J:\tempdb.mdf')
go
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME =
'J:\templog.ldf')
go
where NAME refers to the logical name of the tempdb database and
log files, and where FILENAME refers to the new location of the
tempdb files. Once this command has run, you must restart the
mssqlserver service before it takes affect.
Thanks
Hari
MCDBA
"Tim" <anonymous@.discussions.microsoft.com> wrote in message
news:116c201c3f4ac$1e7d8280$a501280a@.phx
.gbl...
>
> I would like to move my server TempDB file from F: to J:
> drive. What are the steps to complete this tasks?
> Thank You,
> Tim

Move SQL Server and Analysis Service from C: to D:

Hi all,

We need to move the sql server and analysis Service and report server from C: to D:. Can some one outline the steps how should precede without losing any data? I am new at SQL Database, a detailed outline will be appreciated.

Thanks,

Yankua

Easiest, could be to create backup of all of your databases and re-install all products on another drive.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Move database file

I want to move my database file to a new directory, I search in MS and I use the following steps:

USE master;

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = DB_ID(N'test');

ALTER DATABASE test SET OFFLINE;

ALTER DATABASE test

MODIFY FILE ( NAME = test_Log,

FILENAME = 'D:\Databases\test_log.ldf');

ALTER DATABASE test

MODIFY FILE ( NAME = test,

FILENAME = 'D:\Databases\test.mdf');

ALTER DATABASE test

MODIFY FILE ( NAME = test_Log,

FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test_log.ldf');

ALTER DATABASE test SET ONLINE;

But I had the following errors:

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "D:\Databases\test.mdf". Operating system error 5: "5(error not found)".

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "D:\Databases\test_log.ldf". Operating system error 5: "5(error not found)".

File activation failure. The physical file name "D:\Databases\test_log.ldf" may be incorrect.

Msg 945, Level 14, State 2, Line 1

Database 'test' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

Can someone tell me how to move my database to another directory (in the same server instance)?

Thanks ina dvance

In between the lines:

ALTER DATABASE test SET OFFLINE;

ALTER DATABASE test

You should make sure to copy the database files to the new location. The errors point to the fact that the files aren't there. You can find step-by-step instructions here:

http://msdn2.microsoft.com/en-us/library/ms345483.aspx

Buck Woody

|||

Try using detach and attach method to copy the datbase file to new location and attach it from the new location.

Much better way to do the same

thankx

Move database file

I want to move my database file to a new directory, I search in MS and I use the following steps:

USE master;

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = DB_ID(N'test');

ALTER DATABASE test SET OFFLINE;

ALTER DATABASE test

MODIFY FILE ( NAME = test_Log,

FILENAME = 'D:\Databases\test_log.ldf');

ALTER DATABASE test

MODIFY FILE ( NAME = test,

FILENAME = 'D:\Databases\test.mdf');

ALTER DATABASE test

MODIFY FILE ( NAME = test_Log,

FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test_log.ldf');

ALTER DATABASE test SET ONLINE;

But I had the following errors:

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "D:\Databases\test.mdf". Operating system error 5: "5(error not found)".

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "D:\Databases\test_log.ldf". Operating system error 5: "5(error not found)".

File activation failure. The physical file name "D:\Databases\test_log.ldf" may be incorrect.

Msg 945, Level 14, State 2, Line 1

Database 'test' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

Can someone tell me how to move my database to another directory (in the same server instance)?

Thanks ina dvance

In between the lines:

ALTER DATABASE test SET OFFLINE;

ALTER DATABASE test

You should make sure to copy the database files to the new location. The errors point to the fact that the files aren't there. You can find step-by-step instructions here:

http://msdn2.microsoft.com/en-us/library/ms345483.aspx

Buck Woody

|||

Try using detach and attach method to copy the datbase file to new location and attach it from the new location.

Much better way to do the same

thankx