moving sql srvr logs

what is the quickest and safest way to move sql srvr logs
to a different partition in the server.
is there a way to do it using enterprise manager?
thanx team!!I think i found the solution
detaching the database, then phisically moving the logs
to a different partition
and after that re attaching the database
please confirm that this is correct
Thanx
>--Original Message--
>what is the quickest and safest way to move sql srvr
logs
>to a different partition in the server.
>is there a way to do it using enterprise manager?
>thanx team!!
>.
>|||Yep. Read KB 224071 for more info.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"dalatingod" <dalatingod@.hotmail.com> wrote in message
news:12ac501c3f6c6$2248a6d0$a001280a@.phx.gbl...
> I think i found the solution
> detaching the database, then phisically moving the logs
> to a different partition
> and after that re attaching the database
> please confirm that this is correct
> Thanx
>
> >--Original Message--
> >what is the quickest and safest way to move sql srvr
> logs
> >to a different partition in the server.
> >is there a way to do it using enterprise manager?
> >
> >thanx team!!
> >.
> >|||hi,
1. sp_helpdb pubs , will show u the existing file path
of .mdf and .ldf files.
output:
C:\database\Pubs.mdf
C:\database\Pubs_log.ldf
2. sp_detach_db 'pubs','false'
will detach the database and run UPDATE STATISTICS on all
the tables before detaching.
once detached ,copy the .ldf file to the desired location.
Assuming that u r moving pubs_log.ldf to D drive, execute
point 3.
3. EXEC sp_attach_db @.dbname = 'pubs',
@.filename1 = 'C:\Database\pubs.mdf',
@.filename2 = 'D:\Database\pubs_log.ldf'
4. You can execute Point 1 to see the new path. You may
also delete the .ldf file from the old location.
HTH
Regards
Thirumal
>--Original Message--
>I think i found the solution
>detaching the database, then phisically moving the logs
>to a different partition
>and after that re attaching the database
>please confirm that this is correct
>Thanx
>
>>--Original Message--
>>what is the quickest and safest way to move sql srvr
>logs
>>to a different partition in the server.
>>is there a way to do it using enterprise manager?
>>thanx team!!
>>.
>.
>|||Cheers Tibor
the KB describes it in a lot of detail
many many Thanks!!
>--Original Message--
>Yep. Read KB 224071 for more info.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"dalatingod" <dalatingod@.hotmail.com> wrote in message
>news:12ac501c3f6c6$2248a6d0$a001280a@.phx.gbl...
>> I think i found the solution
>> detaching the database, then phisically moving the logs
>> to a different partition
>> and after that re attaching the database
>> please confirm that this is correct
>> Thanx
>>
>> >--Original Message--
>> >what is the quickest and safest way to move sql srvr
>> logs
>> >to a different partition in the server.
>> >is there a way to do it using enterprise manager?
>> >
>> >thanx team!!
>> >.
>> >
>
>.
>

moving reports in report manager

When we move reports from one folder to another in Report Manager we have to delete the report in the destination folder first before moving it over if a version is already there. If not we get the error that an item with that name already exists. Is there a way around this? Is there a setting which will allow over-write of a report?I guess there is non in the graphical tool.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Moving Report Manager

I need to move the report manager from one computer to another computer.
Currently the RS database is on a db server, separate from the report
manager. This will stay the same. I need to know what the steps are for
moving the Report Manager to this new server, and keep all my
folders/schedules intact.Hello dachrist,
The first step would be to install Reporting Services on the new server. If
you are installing Standard Edition you can not choose the database during
the installation, however, you can use a combination of two command line
utilities to connect to the existing database post install. These are:
rsconfig and rsactivate. rsconfig sets the connection information to the
database and a basic syntax would be:
rsconfig -c -s DBServerName -d ReportServer -a SQL -u SQLUsername -P
Password
The "-d" option specifies the ReportServer database and "-a" sets the
authentication type to SQL authentication. rsconfig will be run on the new
Reporting Services Server.
You then run rsactivate on the dbserver to activate the new Reporting
Services Server you just installed, what you referred to as the Report
Manager. .
rsactivate -m NewReportingServicesServer -u Username -p Password
Username and Password will be the Windows account with administrative
priveleges to the Reporting Services Web Service.
I hope this helps.
Rodney Landrum
Author : "Pro SQL Reporting Services" (Apress)
www.apress.com
"dachrist" <dachrist@.discussions.microsoft.com> wrote in message
news:5FAE2190-1179-4FE6-BA4D-FB552C6D9D8F@.microsoft.com...
>I need to move the report manager from one computer to another computer.
> Currently the RS database is on a db server, separate from the report
> manager. This will stay the same. I need to know what the steps are for
> moving the Report Manager to this new server, and keep all my
> folders/schedules intact.