Moving Transaction Log file to different partition

How to do that when I have already created database which have database and
log files on same partition. What I need is to move log file to another
partition.
DubravkoUse sp_detach_db and sp_attach_db. See KB 224071 for more info.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"duby" <duby72002@.yahoo.com> wrote in message news:u6W1bi5nDHA.684@.TK2MSFTNGP09.phx.gbl...
> How to do that when I have already created database which have database and
> log files on same partition. What I need is to move log file to another
> partition.
> Dubravko
>|||detach and transfer
--
Shaju Thomas
e-Cosmos Technologies Ltd.,
Mail: shaju@.e-cosmostech.com
Phone(Off) : 51217038/39 Extn: 132
Mobile: +91 98455 21794
"duby" <duby72002@.yahoo.com> wrote in message
news:u6W1bi5nDHA.684@.TK2MSFTNGP09.phx.gbl...
> How to do that when I have already created database which have database
and
> log files on same partition. What I need is to move log file to another
> partition.
> Dubravko
>sql

Moving SQL to a partition

I need to move an SQL database from the C: partition to
another partition. Is there a way to do it that will not
cause errors?
Is there a way to increase the partition size without a
full re-intall of Windows Server 2000?
Brice
hi Brice,
"Brice Sutliff" <bsutliff@.socfc.org> ha scritto nel messaggio
news:088701c4e465$90d674a0$a301280a@.phx.gbl
> I need to move an SQL database from the C: partition to
> another partition. Is there a way to do it that will not
> cause errors?
> Is there a way to increase the partition size without a
> full re-intall of Windows Server 2000?
> Brice
Partition Magic probably can do the trick, for increase partition sizes...
as long as moving databases, please have a look at
http://support.microsoft.com/?id=314546 and
http://www.support.microsoft.com/?id=224071
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

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!!Yep. Read KB 224071 for more info.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.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
>
> logs|||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...
>
>.
>

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 SQL installation to a new Partition

Hello,
I have a SQL 2000 installation on a small partion that I would like to
move to a second larger partion on the same disk array array with the
config as follows:
d: full installation of prod and test instances with data and log files
100 GB
e: empty partion with 204 GB which I want to move the "whole thing"

I did an Xcopy of all files,permissions and attributes, checked for
errors, then I changed drive
letters and restarted. Only one instance came up (the other threw an
error of: MSSQL,,the system cannot find the file specified.

I realize that I could detatch the DB's and move them leaving the base
install on the old partition however I would like to simulate the loss
of the disk array and the restore to said array from a backup.
(ultimately I want to delete the 2 partitions and restore from tape to
a single 300GB d: partition)

I am trying to buy time and avoid a re-install of SQL untill I can get
a whole new platform.
I can work it out on my own if someone can point me in the right
direction. I suspect a registry entry to a disk id (partition)Marc C (mchang@.allosource.org) writes:

Quote:

Originally Posted by

Hello,
I have a SQL 2000 installation on a small partion that I would like to
move to a second larger partion on the same disk array array with the
config as follows:
d: full installation of prod and test instances with data and log files
100 GB
e: empty partion with 204 GB which I want to move the "whole thing"
>
I did an Xcopy of all files,permissions and attributes, checked for
errors, then I changed drive
letters and restarted. Only one instance came up (the other threw an
error of: MSSQL,,the system cannot find the file specified.
>
I realize that I could detatch the DB's and move them leaving the base
install on the old partition however I would like to simulate the loss
of the disk array and the restore to said array from a backup.

Good! You've just done that and found that it does not work!

OK, assuming that you had stopped SQL Server prior you started copying,
the operation as you described it, should work I think. But if there is
a file you missed a long the way there may be trouble.

But for restoring from backup... You can't really just back up the disk
drive as such, you need to use SQL Servers own BACKUP command, so that
backups are consistent. (Well, if you stop SQL Server before you start
the backup, you might get away with it, but normally you don't want to
do that.)

Quote:

Originally Posted by

I am trying to buy time and avoid a re-install of SQL untill I can get
a whole new platform.
I can work it out on my own if someone can point me in the right
direction. I suspect a registry entry to a disk id (partition)

I don't think there is any. Rather I would look at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters
as the prime suspect.

Exactly where do you get this error?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks for your reply. I get the error on boot/startup. It's possible I
had a file open during the copy so the sql service cannot find a file
at startup. I will look into the logs for more detailed errors when I
try again during my next maintenance window. however the sql errorlog
shows no entries during that time span -so it's likely sql never
starts.

The only record of the failure was in the System Event log event id-
7000 Source- Service Control Manager with teh message The
MSSQL$Instancename service failer to start due to the following error:
the system cannot find the file specified.|||Marc C (mchang@.allosource.org) writes:

Quote:

Originally Posted by

Thanks for your reply. I get the error on boot/startup. It's possible I
had a file open during the copy so the sql service cannot find a file
at startup. I will look into the logs for more detailed errors when I
try again during my next maintenance window. however the sql errorlog
shows no entries during that time span -so it's likely sql never
starts.

Hm, that would indicate that a DLL or somesuch is missing rather than a
database file.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx