Moving cluster server to new location

We are in the process of migrating our data center to a new location. we
have a cluster server running win2k advance server active passive mode with
Sql server 2000 on it. Any one has any ideas or best practice notes on the
best way to do it.Hi
I guess your IP address wil change:
Changing the IP Address of Network Adapters in Cluster Server
http://support.microsoft.com/default.aspx?kbid=230356
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/defaul...0&Product=sql2k
Test as much as you can beforehand. Make a checklist before starting.
(Credit to Geoff N. Hiten for the original answer in
microsoft.public.sqlserver.clustering)
Regards
Mike
"sumsuk" wrote:

> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode wit
h
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.|||Is it better to build a new cluster server at the new site. backup system
and user database from the old server then restore the data on the new
server. Any one had done this , will this work.
If we cannot afford down time then what is the best way to sync. the two
server.
If i am physicaly moving the old server to the new location do you think i
will have to break the cluster because the storage is on a san in the
current location.
My planning is in a very primitive stage now. Any input is apprieciated.
Thanx.
"sumsuk" wrote:

> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode wit
h
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.sql

Moving cluster server to new location

We are in the process of migrating our data center to a new location. we
have a cluster server running win2k advance server active passive mode with
Sql server 2000 on it. Any one has any ideas or best practice notes on the
best way to do it.Hi
I guess your IP address wil change:
Changing the IP Address of Network Adapters in Cluster Server
http://support.microsoft.com/default.aspx?kbid=230356
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;244980&Product=sql2k
Test as much as you can beforehand. Make a checklist before starting.
(Credit to Geoff N. Hiten for the original answer in
microsoft.public.sqlserver.clustering)
Regards
Mike
"sumsuk" wrote:
> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode with
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.|||Is it better to build a new cluster server at the new site. backup system
and user database from the old server then restore the data on the new
server. Any one had done this , will this work.
If we cannot afford down time then what is the best way to sync. the two
server.
If i am physicaly moving the old server to the new location do you think i
will have to break the cluster because the storage is on a san in the
current location.
My planning is in a very primitive stage now. Any input is apprieciated.
Thanx.
"sumsuk" wrote:
> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode with
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.

Moving cluster server to new location

We are in the process of migrating our data center to a new location. we
have a cluster server running win2k advance server active passive mode with
Sql server 2000 on it. Any one has any ideas or best practice notes on the
best way to do it.
Hi
I guess your IP address wil change:
Changing the IP Address of Network Adapters in Cluster Server
http://support.microsoft.com/default.aspx?kbid=230356
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/default...&Product=sql2k
Test as much as you can beforehand. Make a checklist before starting.
(Credit to Geoff N. Hiten for the original answer in
microsoft.public.sqlserver.clustering)
Regards
Mike
"sumsuk" wrote:

> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode with
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.
|||Is it better to build a new cluster server at the new site. backup system
and user database from the old server then restore the data on the new
server. Any one had done this , will this work.
If we cannot afford down time then what is the best way to sync. the two
server.
If i am physicaly moving the old server to the new location do you think i
will have to break the cluster because the storage is on a san in the
current location.
My planning is in a very primitive stage now. Any input is apprieciated.
Thanx.
"sumsuk" wrote:

> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode with
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.

Moving C2 Audits

I'm not seeing or finding how to move the location of the C2 Audit files. I
used the pretty standard script to enable C2 Auditing:
EXEC sp_configure 'show advanced option', 1
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'c2 audit mode', 1
RECONFIGURE WITH OVERRIDE
However, it would be nice if I could move them from the C:\ drive to a
folder already being backed up since we need these audit trails for at least
one year (Government thing). Any ideas? I'll keep looking, but I know we
get pretty quick responses in here also!
Thanks
AllenSorry , what is C2 Audit files ?
"A McGuire" <allen.mcguire@.gmail.com.invalid> wrote in message
news:e4aqFxLtGHA.2260@.TK2MSFTNGP03.phx.gbl...
> I'm not seeing or finding how to move the location of the C2 Audit files.
> I used the pretty standard script to enable C2 Auditing:
> EXEC sp_configure 'show advanced option', 1
> RECONFIGURE WITH OVERRIDE
> EXEC sp_configure 'c2 audit mode', 1
> RECONFIGURE WITH OVERRIDE
> However, it would be nice if I could move them from the C:\ drive to a
> folder already being backed up since we need these audit trails for at
> least one year (Government thing). Any ideas? I'll keep looking, but I
> know we get pretty quick responses in here also!
> Thanks
> Allen
>|||Hi,
By default SQL Server logs the C2 trace into data folder which you mentioned
during SQL Server installation.
The file can be copied to a different location by writing a batch file and
scheduled using SQL Server Agent every 1 hour.
Thanks
Hari
SQL Server MVP
"A McGuire" <allen.mcguire@.gmail.com.invalid> wrote in message
news:e4aqFxLtGHA.2260@.TK2MSFTNGP03.phx.gbl...
> I'm not seeing or finding how to move the location of the C2 Audit files.
> I used the pretty standard script to enable C2 Auditing:
> EXEC sp_configure 'show advanced option', 1
> RECONFIGURE WITH OVERRIDE
> EXEC sp_configure 'c2 audit mode', 1
> RECONFIGURE WITH OVERRIDE
> However, it would be nice if I could move them from the C:\ drive to a
> folder already being backed up since we need these audit trails for at
> least one year (Government thing). Any ideas? I'll keep looking, but I
> know we get pretty quick responses in here also!
> Thanks
> Allen
>|||C2 audits are predefined audits you can run to trace specific events on a
SQL Server. It is compliant with Government auditing policies and
procedures.
http://www.microsoft.com/technet/se...r/sql2kaud.mspx
A Google search will produce more results for you.
In SQL 2005 it is a standard checkbox you can turn on by checking the
Properties of a Server, then clicking on Security. In SQL 2000, you have to
run the script I show below.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uX%23l0rStGHA.4748@.TK2MSFTNGP03.phx.gbl...
> Sorry , what is C2 Audit files ?
>
>
> "A McGuire" <allen.mcguire@.gmail.com.invalid> wrote in message
> news:e4aqFxLtGHA.2260@.TK2MSFTNGP03.phx.gbl...
>|||Yeah, not really what I had in mind though. Just like I can change the
location of my data files and log files, I want my traces to go to another
location as well. This should be something we can run a script to configure
IMHO. I don't want to write batch files for each of my 70 SQL Servers ;-)
The default size of an audit file is 200 MB, and with C2 auditing, that will
be reached daily for some servers - no way around it. Furthermore, you
can't copy an active trace file, so I would have to continually check back
to see if the thing is 200 MB yet, then copy it to another location on the
same computer - awaiting pickup by our backup system. That is way too much
disk activity for me.
I would like to see the ability to write them directly to another location -
other than the original /data folder.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uY92JSUtGHA.4968@.TK2MSFTNGP03.phx.gbl...
> Hi,
> By default SQL Server logs the C2 trace into data folder which you
> mentioned during SQL Server installation.
> The file can be copied to a different location by writing a batch file and
> scheduled using SQL Server Agent every 1 hour.
> Thanks
> Hari
> SQL Server MVP
>
> "A McGuire" <allen.mcguire@.gmail.com.invalid> wrote in message
> news:e4aqFxLtGHA.2260@.TK2MSFTNGP03.phx.gbl...
>|||Ok - I've been told that audits get written to the default data directory.
However, we have dedicated drives for log and data files (E: and F:, for
example). What I had to do to get the C2 audits (trace files) to write to
our data directory was:
1) launch Enterprise Manager
2) right-click and Properties
3) Database Settings tab
4) Change 'default data directory' to F:\<location>
5) Stop and restart the services
Good to go. The traces will begin writing to the drive you specified as
your default data directory.
"A McGuire" <allen.mcguire@.gmail.com.invalid> wrote in message
news:e4aqFxLtGHA.2260@.TK2MSFTNGP03.phx.gbl...
> I'm not seeing or finding how to move the location of the C2 Audit files.
> I used the pretty standard script to enable C2 Auditing:
> EXEC sp_configure 'show advanced option', 1
> RECONFIGURE WITH OVERRIDE
> EXEC sp_configure 'c2 audit mode', 1
> RECONFIGURE WITH OVERRIDE
> However, it would be nice if I could move them from the C:\ drive to a
> folder already being backed up since we need these audit trails for at
> least one year (Government thing). Any ideas? I'll keep looking, but I
> know we get pretty quick responses in here also!
> Thanks
> Allen
>sql

moving a SQl 2005 log file

I do you move the log file to a different drive and leave the database
in its current location with SQL 2005?
Thanks for your help,
Mark
Mark,
See "alter database ... modify file ..." in BOL.
AMB
"Mark" wrote:

> I do you move the log file to a different drive and leave the database
> in its current location with SQL 2005?
> Thanks for your help,
> Mark
>
|||In addition to the ALTER DATABASE topic, the topic Moving User Databases
http://msdn2.microsoft.com/en-us/library/ms345483.aspx provides step-by-step
instructions for moving files.
Regards,
Gail
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:78B38875-979A-4973-A97F-7C7669A7F1A2@.microsoft.com...[vbcol=seagreen]
> Mark,
> See "alter database ... modify file ..." in BOL.
>
> AMB
> "Mark" wrote:
|||Gail Erickson [MS]" ,
I have to get use to look more closely into the BOL. The SQL Server
Documentation Team is doing a great job.
Thanks,
AMB
"Gail Erickson [MS]" wrote:

> In addition to the ALTER DATABASE topic, the topic Moving User Databases
> http://msdn2.microsoft.com/en-us/library/ms345483.aspx provides step-by-step
> instructions for moving files.
> Regards,
> Gail
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
> news:78B38875-979A-4973-A97F-7C7669A7F1A2@.microsoft.com...
>
>
|||> I have to get use to look more closely into the BOL. The SQL Server
> Documentation Team is doing a great job.
Thanks!
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:32E9A595-9FA3-42E1-892C-951FF36FF095@.microsoft.com...[vbcol=seagreen]
> Gail Erickson [MS]" ,
> I have to get use to look more closely into the BOL. The SQL Server
> Documentation Team is doing a great job.
> Thanks,
> AMB
>
> "Gail Erickson [MS]" wrote:
|||Hello,
You could use ALTER DATABASE...MODIFYFILE. THis will change the LDF path in
the system table. Once you restart the SQL Server
automatically this will come into effect.
You can also use SP_DETACH_DB and SP_ATTACH_DB
Thanks
Hari
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:78B38875-979A-4973-A97F-7C7669A7F1A2@.microsoft.com...[vbcol=seagreen]
> Mark,
> See "alter database ... modify file ..." in BOL.
>
> AMB
> "Mark" wrote:
sql

moving a SQl 2005 log file

I do you move the log file to a different drive and leave the database
in its current location with SQL 2005?
Thanks for your help,
MarkMark,
See "alter database ... modify file ..." in BOL.
AMB
"Mark" wrote:

> I do you move the log file to a different drive and leave the database
> in its current location with SQL 2005?
> Thanks for your help,
> Mark
>|||In addition to the ALTER DATABASE topic, the topic Moving User Databases
http://msdn2.microsoft.com/en-us/library/ms345483.aspx provides step-by-step
instructions for moving files.
Regards,
Gail
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/pr...oads/books.mspx
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:78B38875-979A-4973-A97F-7C7669A7F1A2@.microsoft.com...[vbcol=seagreen]
> Mark,
> See "alter database ... modify file ..." in BOL.
>
> AMB
> "Mark" wrote:
>|||Gail Erickson [MS]" ,
I have to get use to look more closely into the BOL. The SQL Server
Documentation Team is doing a great job.
Thanks,
AMB
"Gail Erickson [MS]" wrote:

> In addition to the ALTER DATABASE topic, the topic Moving User Databases
> http://msdn2.microsoft.com/en-us/library/ms345483.aspx provides step-by-st
ep
> instructions for moving files.
> Regards,
> Gail
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://www.microsoft.com/technet/pr...oads/books.mspx
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in messag
e
> news:78B38875-979A-4973-A97F-7C7669A7F1A2@.microsoft.com...
>
>|||> I have to get use to look more closely into the BOL. The SQL Server
> Documentation Team is doing a great job.
Thanks!
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/pr...oads/books.mspx
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:32E9A595-9FA3-42E1-892C-951FF36FF095@.microsoft.com...[vbcol=seagreen]
> Gail Erickson [MS]" ,
> I have to get use to look more closely into the BOL. The SQL Server
> Documentation Team is doing a great job.
> Thanks,
> AMB
>
> "Gail Erickson [MS]" wrote:
>|||Hello,
You could use ALTER DATABASE...MODIFYFILE. THis will change the LDF path in
the system table. Once you restart the SQL Server
automatically this will come into effect.
You can also use SP_DETACH_DB and SP_ATTACH_DB
Thanks
Hari
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:78B38875-979A-4973-A97F-7C7669A7F1A2@.microsoft.com...[vbcol=seagreen]
> Mark,
> See "alter database ... modify file ..." in BOL.
>
> AMB
> "Mark" wrote:
>

moving a SQl 2005 log file

I do you move the log file to a different drive and leave the database
in its current location with SQL 2005?
Thanks for your help,
MarkMark,
See "alter database ... modify file ..." in BOL.
AMB
"Mark" wrote:
> I do you move the log file to a different drive and leave the database
> in its current location with SQL 2005?
> Thanks for your help,
> Mark
>|||In addition to the ALTER DATABASE topic, the topic Moving User Databases
http://msdn2.microsoft.com/en-us/library/ms345483.aspx provides step-by-step
instructions for moving files.
Regards,
Gail
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:78B38875-979A-4973-A97F-7C7669A7F1A2@.microsoft.com...
> Mark,
> See "alter database ... modify file ..." in BOL.
>
> AMB
> "Mark" wrote:
>> I do you move the log file to a different drive and leave the database
>> in its current location with SQL 2005?
>> Thanks for your help,
>> Mark|||Gail Erickson [MS]" ,
I have to get use to look more closely into the BOL. The SQL Server
Documentation Team is doing a great job.
Thanks,
AMB
"Gail Erickson [MS]" wrote:
> In addition to the ALTER DATABASE topic, the topic Moving User Databases
> http://msdn2.microsoft.com/en-us/library/ms345483.aspx provides step-by-step
> instructions for moving files.
> Regards,
> Gail
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
> news:78B38875-979A-4973-A97F-7C7669A7F1A2@.microsoft.com...
> > Mark,
> >
> > See "alter database ... modify file ..." in BOL.
> >
> >
> > AMB
> >
> > "Mark" wrote:
> >
> >> I do you move the log file to a different drive and leave the database
> >> in its current location with SQL 2005?
> >>
> >> Thanks for your help,
> >> Mark
> >>
>
>|||> I have to get use to look more closely into the BOL. The SQL Server
> Documentation Team is doing a great job.
Thanks!
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:32E9A595-9FA3-42E1-892C-951FF36FF095@.microsoft.com...
> Gail Erickson [MS]" ,
> I have to get use to look more closely into the BOL. The SQL Server
> Documentation Team is doing a great job.
> Thanks,
> AMB
>
> "Gail Erickson [MS]" wrote:
>> In addition to the ALTER DATABASE topic, the topic Moving User Databases
>> http://msdn2.microsoft.com/en-us/library/ms345483.aspx provides
>> step-by-step
>> instructions for moving files.
>> Regards,
>> Gail
>> --
>> Gail Erickson [MS]
>> SQL Server Documentation Team
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights
>> Download the latest version of Books Online from
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
>> message
>> news:78B38875-979A-4973-A97F-7C7669A7F1A2@.microsoft.com...
>> > Mark,
>> >
>> > See "alter database ... modify file ..." in BOL.
>> >
>> >
>> > AMB
>> >
>> > "Mark" wrote:
>> >
>> >> I do you move the log file to a different drive and leave the database
>> >> in its current location with SQL 2005?
>> >>
>> >> Thanks for your help,
>> >> Mark
>> >>
>>|||Hello,
You could use ALTER DATABASE...MODIFYFILE. THis will change the LDF path in
the system table. Once you restart the SQL Server
automatically this will come into effect.
You can also use SP_DETACH_DB and SP_ATTACH_DB
Thanks
Hari
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:78B38875-979A-4973-A97F-7C7669A7F1A2@.microsoft.com...
> Mark,
> See "alter database ... modify file ..." in BOL.
>
> AMB
> "Mark" wrote:
>> I do you move the log file to a different drive and leave the database
>> in its current location with SQL 2005?
>> Thanks for your help,
>> Mark

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 Transaction Log

I want to move the transaction log from its current
location (same as the databases) to a different drive for
performance reasons. How do I do that?Check out sp_detach_db and sp_attach_db in the BOL.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Keith" <dkcamc@.yahoo.com> wrote in message
news:1d4301c49b5e$504e5b00$3a01280a@.phx.gbl...
I want to move the transaction log from its current
location (same as the databases) to a different drive for
performance reasons. How do I do that?|||http://www.support.microsoft.com/?id=224071
Andrew J. Kelly SQL MVP
"Keith" <dkcamc@.yahoo.com> wrote in message
news:1d4301c49b5e$504e5b00$3a01280a@.phx.gbl...
> I want to move the transaction log from its current
> location (same as the databases) to a different drive for
> performance reasons. How do I do that?|||Sorry if I'm dragging an old thread up, but I need to do this also. I've
tried using the SP_Detatch command, but it refuses to move the log, due to
having replications attached. Is there anyway I can move the TNS log without
deleting the replications and starting again?
Cheers
Steve
"Keith" wrote:
> I want to move the transaction log from its current
> location (same as the databases) to a different drive for
> performance reasons. How do I do that?
>

move the database file to another location

I have the database on the SQLDBSRV server but the sapec is not enough for the data and I want to move the file to another server SQLFILESRV without moving the whole server.. I mean just the data file.. Is that possible?

Here is a Microsoft Knowledge Base article on how to move a database using the Detach/Attach method: http://support.microsoft.com/default.aspx/kb/224071/

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

but ATTACHing the database means it will copy the file into the Data folder on the server? right?

What I want is having the actual sql server on ServerA and the data file on ServerB

|||

Hi,

AFAIK it is not possible to have database files on another server /mapping a files because it should remain on the same server and its not the best practice also this would lead to severe issues also like

NETWORK Bandwidth Consumption

Backingup/restoration

if in case it goes in suspect / offline

|||

It's possible to move the database file to another location and ATTCHing it to the server which will not actually move the data and log file to the default Data directory but instead point to the new location and hence there is no redundancy.

This works well until the database file are located into the same server, irrespective of the location in the server. But it's not possible to attach a database whose data and log files are located to another server location as the sp_attach_db SP throws an error : "The location of the mdf file on a network path is not supported for datbase files" while giving the path of the database file on another server location.

Regards,

Rajesh

|||

then is it possible to map the network drive so it will be D or E on the server and move the file to it?

another questions plz: what files should i move? just the mdf file?

|||

Hi Jassim,

I tried mapping the share on another server to a local network drive but it doesn't works. I guess it's not supported as of now.

You can report this issue through MSDN product feedback center by selecting “Send Feedback” menu item under “Community” Menu in SQL Server Management Studio. You can also file bugs directly on http://connect.microsoft.com/sqlserver/feedback which will help you to track the status of the bug.

Regarding your second question, it would be good if you move mdf as well ldf files to one common location.

Regards,

Rajesh

|||Network databases are normally not recommended. Unless your network storage meets strict I/O requirements, it's _not_ supported.

That's said, you can mount a network database if you enable trace flag 1807.

http://support.microsoft.com/kb/304261
http://msdn2.microsoft.com/en-us/library/ms176061.aspx
http://www.microsoft.com/sql/alwayson/default.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspxsql

Move RS log files

Is there a way to change the location of the Reporting Services Log Files?
I've seen several folks ask this question but no answer as of yet.
Thanks,
JoeYou need to modify the web.config and ReportingServicesService.exe.config
files. Look for the RSTrace element and add a new line like follows:
<add name="Directory" value="location you would like" />
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe Clifford" <Joe Clifford@.discussions.microsoft.com> wrote in message
news:842A5546-99DC-455C-8B64-BCE09F86771C@.microsoft.com...
> Is there a way to change the location of the Reporting Services Log Files?
> I've seen several folks ask this question but no answer as of yet.
> Thanks,
> Joe
>
>

Move Log Files From C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG To E:\MSSQL Logs

How do I move the default log files placed in: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG to a different location? I want to place them in a partition I have setup which stores log files? Reason being is that this log directory is getting quite large, 600MB and I want to conserve space on my C:\ partition.

Thanks.

You can move the files using sp_detach_db and sp_attach_db. You can find the steps explained in the following article:

How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server

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

-Sue

|||

Sue:

Acutally I dont want to move any database files, what I want to move is simply the log files, just errors, activity and such. The files reside in the /log directory not the /data directory.

Thanks for the help.

|||

For the SQL error log, open up SQL Server Configuration Manager. Select the SQL Services node, double click on SQL Server in the right pane and go to the advanced tab. View the startup parameters. The path following -e is for the error log. See the books online topic: Using the SQL Server Service Startup Options.

You can use Configuration Manager to change the path for SQL Agent as well. Select the service node, double click on SQL Server agent and go to the advanced tab. Change the path for the dump directory.

In terms of the default trace, that will default to your installation directory. You can create your own trace if you want another location.

-Sue

|||

Thanks Sue that did the trick.

Changed dump directory to: E:\MSSQL and startup parameters e to E:\MSSQL\ERRORLOG and restarted the service.

move log file to diff location

Hi,
I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.
Please don't multi-post. See my answer in .clustering.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23lg8C4luHHA.1768@.TK2MSFTNGP04.phx.gbl...
Hi,
I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.

move log file to diff location

Hi,
I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.Please don't multi-post. See my answer in .clustering.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23lg8C4luHHA.1768@.TK2MSFTNGP04.phx.gbl...
Hi,
I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.

move log file to diff location

Hi,
I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.Please don't multi-post. See my answer in .clustering.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23lg8C4luHHA.1768@.TK2MSFTNGP04.phx.gbl...
Hi,
I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.

Moving instance of Sql server to different location

Is it possible to move an instance sql server from one drive to another, i.e
.
C: to D: without changing connection properties referenced in DTS packages,
etc.?
T.I.A.This should help:
http://support.microsoft.com/kb/224071
-oj
"LNN" <LNN@.discussions.microsoft.com> wrote in message
news:BE7ADDBD-6113-4BB2-9695-DEB61FC00A91@.microsoft.com...
> Is it possible to move an instance sql server from one drive to another,
> i.e.
> C: to D: without changing connection properties referenced in DTS
> packages,
> etc.?
> T.I.A.|||Hi
If you are moving a database then the connection properties will not change
if you following the instructions in the link posted by oj. If you are
rebuilding a new server and want to rename that server (to be the original
server's name) then you will also need
http://msdn.microsoft.com/library/d...nstall_5r8f.asp
John
"LNN" wrote:

> Is it possible to move an instance sql server from one drive to another, i
.e.
> C: to D: without changing connection properties referenced in DTS packages
,
> etc.?
> T.I.A.