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 Logs to another drive

Does anyone know how to move the SQL logs to another drive. I want to
seperate these from the database for redundancy and performance
I get an error stating the log cannot be moved after the database has been
create.
SQL 2000 STD
Thanks in advance for your helpSee sp_detach/ sp_attach in BOL.
"Bob Smith" <BobSmith@.discussions.microsoft.com> wrote in message
news:D14C7D37-BCF5-4D79-ACCE-95C1F75C4783@.microsoft.com...
> Does anyone know how to move the SQL logs to another drive. I want to
> seperate these from the database for redundancy and performance
> I get an error stating the log cannot be moved after the database has been
> create.
> SQL 2000 STD
> Thanks in advance for your help|||"Bob Smith" <BobSmith@.discussions.microsoft.com> wrote in message
news:D14C7D37-BCF5-4D79-ACCE-95C1F75C4783@.microsoft.com...
> Does anyone know how to move the SQL logs to another drive. I want to
> seperate these from the database for redundancy and performance
> I get an error stating the log cannot be moved after the database has been
> create.
> SQL 2000 STD
> Thanks in advance for your help
sp_attach_db and sp_detach_db can help you here.
Alternately, you could issue a RESTORE DATABASE command specify the new
location using the MOVE TO option.
Rick Sawtell
MCT, MCSD, MCDBA

Move Images (BLOBs) from MSSQL to a folder

Hi Guys.

I have a MSSQL database of 2 gigs which has about 100mb of data, the rest is images.

I have noticed a huge decrease in performance as more images are entered into the database (most images are about 1mb).

I would like to know if there is a way to extract the images from the database and move them to a folder on the server.

Does anyone have experience or suggestions as to how this can be done?

Regards

VVOLTT

Quote:

Originally Posted by vvoltt

Hi Guys.

I have a MSSQL database of 2 gigs which has about 100mb of data, the rest is images.

I have noticed a huge decrease in performance as more images are entered into the database (most images are about 1mb).

I would like to know if there is a way to extract the images from the database and move them to a folder on the server.

Does anyone have experience or suggestions as to how this can be done?

Regards

VVOLTT

Before doing something like this, make sure that your SELECTS are optimized so that they don't pull images unnecessarily, and that your tables are properly indexed. Try taking a look at the execution plan for your slow queries.

The easiest way to do something like this would be to create a simple interface to query each row, and then write the data to a file.

moving indexes onto another partition

Hi
From several weeks I suffer poor performance of my SQL Serv (as backend to
the web application).
I heard that sometimes splitting database to different hard disk could raise
performance. But in my case I have got only one HDD devided to 2 partition -
my question is: if it is good idea to migrate tables or indexes to anther
partition - does it make sens?
Or maybe thare is another solution to my problem - connected mostly with HDD
queue legth. So I could say that all the delay in answers are connected with
poor HDD performance.
Best Regards
Darek T.It does not help to move the indexes to the other partition: it is still the
same physical disk drive.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Dariusz Tomon" wrote:

> Hi
> From several weeks I suffer poor performance of my SQL Serv (as backend to
> the web application).
> I heard that sometimes splitting database to different hard disk could rai
se
> performance. But in my case I have got only one HDD devided to 2 partition
-
> my question is: if it is good idea to migrate tables or indexes to anther
> partition - does it make sens?
> Or maybe thare is another solution to my problem - connected mostly with H
DD
> queue legth. So I could say that all the delay in answers are connected wi
th
> poor HDD performance.
>
> Best Regards
> Darek T.
>
>|||Use SQL profiler to run a trace and identify the query that is slow. The
vast majority of performance problems can be fixed by rewriting queries or
adding indexes.
Beyond that, you can only add physical drives to distribute the read/writes.
"Dariusz Tomon" <d.tomon@.mazars.pl> wrote in message
news:O$Q3lgRdGHA.1656@.TK2MSFTNGP02.phx.gbl...
> Hi
> From several weeks I suffer poor performance of my SQL Serv (as backend to
> the web application).
> I heard that sometimes splitting database to different hard disk could
> raise performance. But in my case I have got only one HDD devided to 2
> partition - my question is: if it is good idea to migrate tables or
> indexes to anther partition - does it make sens?
> Or maybe thare is another solution to my problem - connected mostly with
> HDD queue legth. So I could say that all the delay in answers are
> connected with poor HDD performance.
>
> Best Regards
> Darek T.
>

moving indexes onto another partition

Hi
From several weeks I suffer poor performance of my SQL Serv (as backend to
the web application).
I heard that sometimes splitting database to different hard disk could raise
performance. But in my case I have got only one HDD devided to 2 partition -
my question is: if it is good idea to migrate tables or indexes to anther
partition - does it make sens?
Or maybe thare is another solution to my problem - connected mostly with HDD
queue legth. So I could say that all the delay in answers are connected with
poor HDD performance.
Best Regards
Darek T.It does not help to move the indexes to the other partition: it is still the
same physical disk drive.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Dariusz Tomon" wrote:
> Hi
> From several weeks I suffer poor performance of my SQL Serv (as backend to
> the web application).
> I heard that sometimes splitting database to different hard disk could raise
> performance. But in my case I have got only one HDD devided to 2 partition -
> my question is: if it is good idea to migrate tables or indexes to anther
> partition - does it make sens?
> Or maybe thare is another solution to my problem - connected mostly with HDD
> queue legth. So I could say that all the delay in answers are connected with
> poor HDD performance.
>
> Best Regards
> Darek T.
>
>|||Use SQL profiler to run a trace and identify the query that is slow. The
vast majority of performance problems can be fixed by rewriting queries or
adding indexes.
Beyond that, you can only add physical drives to distribute the read/writes.
"Dariusz Tomon" <d.tomon@.mazars.pl> wrote in message
news:O$Q3lgRdGHA.1656@.TK2MSFTNGP02.phx.gbl...
> Hi
> From several weeks I suffer poor performance of my SQL Serv (as backend to
> the web application).
> I heard that sometimes splitting database to different hard disk could
> raise performance. But in my case I have got only one HDD devided to 2
> partition - my question is: if it is good idea to migrate tables or
> indexes to anther partition - does it make sens?
> Or maybe thare is another solution to my problem - connected mostly with
> HDD queue legth. So I could say that all the delay in answers are
> connected with poor HDD performance.
>
> Best Regards
> Darek T.
>