Move tempdb logfiles between partitions?

I am wondering if there's any issues associated with moving the tempdb
logfiles from one partition to another? If not, then what would you
recommend the best way to do this?http://support.microsoft.com/defaul...kb;en-us;224071
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<mikenospam72@.hotmail.com> wrote in message
news:1119212587.406860.87850@.f14g2000cwb.googlegroups.com...
>I am wondering if there's any issues associated with moving the tempdb
> logfiles from one partition to another? If not, then what would you
> recommend the best way to do this?
>

Move tempdb logfiles between partitions?

I am wondering if there's any issues associated with moving the tempdb
logfiles from one partition to another? If not, then what would you
recommend the best way to do this?
http://support.microsoft.com/default...b;en-us;224071
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<mikenospam72@.hotmail.com> wrote in message
news:1119212587.406860.87850@.f14g2000cwb.googlegro ups.com...
>I am wondering if there's any issues associated with moving the tempdb
> logfiles from one partition to another? If not, then what would you
> recommend the best way to do this?
>

Move tempdb logfiles between partitions?

I am wondering if there's any issues associated with moving the tempdb
logfiles from one partition to another? If not, then what would you
recommend the best way to do this?http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<mikenospam72@.hotmail.com> wrote in message
news:1119212587.406860.87850@.f14g2000cwb.googlegroups.com...
>I am wondering if there's any issues associated with moving the tempdb
> logfiles from one partition to another? If not, then what would you
> recommend the best way to do this?
>

Move SQL Databse (in MSDE) to another path

I have a server W2K (and MSDE) with 2 partitions one for
system (3GB) and one for data (37GB).
An application creates ALL SQL databases, in the default
folder for MSDE 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data' in the system partition.
It intended to move the databases for the data partition?
Hi,
Login to SQL Server using OSQL -Usa -Ppassword -Sservername (Enter)
This will allow you to go to a SQL prompt there type the below command to
detach the database (Only for User databases)
1>sp_detach_db <dbname>
2>go
Now you can move the MDF and LDF files to new partition say D:\MSSQL\DATA
After that use the below command in the SQL prompt:-
1>sp_attach_db
'dbname','d:\mssql\data\dbname.mdf',''d:\mssql\dat a\dbname.ldf'
2>go
The above command will attach the database back to SQl Server but in new
partition.
Note: Do the above steps for all the other user databases as well as
Pubs,Northwind.
If you need to do the same for system databases (Master, model , tempdb,
msdb), follow the below link. The link also details movement of user
databases.
http://support.microsoft.com/default...224071&sd=tech
Thanks
Hari
MCDBA
"Batista" <carlos.batista@.cmz.pt> wrote in message
news:ac3b01c43692$bc1bf350$a501280a@.phx.gbl...
> I have a server W2K (and MSDE) with 2 partitions one for
> system (3GB) and one for data (37GB).
> An application creates ALL SQL databases, in the default
> folder for MSDE 'c:\Program Files\Microsoft SQL
> Server\MSSQL\Data' in the system partition.
> It intended to move the databases for the data partition?
>

Move SQL Databse (in MSDE) to another path

I have a server W2K (and MSDE) with 2 partitions one for
system (3GB) and one for data (37GB).
An application creates ALL SQL databases, in the default
folder for MSDE 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data' in the system partition.
It intended to move the databases for the data partition?Hi,
Login to SQL Server using OSQL -Usa -Ppassword -Sservername (Enter)
This will allow you to go to a SQL prompt there type the below command to
detach the database (Only for User databases)
1>sp_detach_db <dbname>
2>go
Now you can move the MDF and LDF files to new partition say D:\MSSQL\DATA
After that use the below command in the SQL prompt:-
1>sp_attach_db
'dbname','d:\mssql\data\dbname.mdf',''d:\mssql\data\dbname.ldf'
2>go
The above command will attach the database back to SQl Server but in new
partition.
Note: Do the above steps for all the other user databases as well as
Pubs,Northwind.
If you need to do the same for system databases (Master, model , tempdb,
msdb), follow the below link. The link also details movement of user
databases.
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&sd=tech
Thanks
Hari
MCDBA
"Batista" <carlos.batista@.cmz.pt> wrote in message
news:ac3b01c43692$bc1bf350$a501280a@.phx.gbl...
> I have a server W2K (and MSDE) with 2 partitions one for
> system (3GB) and one for data (37GB).
> An application creates ALL SQL databases, in the default
> folder for MSDE 'c:\Program Files\Microsoft SQL
> Server\MSSQL\Data' in the system partition.
> It intended to move the databases for the data partition?
>

Move SQL Databse (in MSDE) to another path

I have a server W2K (and MSDE) with 2 partitions one for
system (3GB) and one for data (37GB).
An application creates ALL SQL databases, in the default
folder for MSDE 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data' in the system partition.
It intended to move the databases for the data partition?Hi,
Login to SQL Server using OSQL -Usa -Ppassword -Sservername (Enter)
This will allow you to go to a SQL prompt there type the below command to
detach the database (Only for User databases)
1>sp_detach_db <dbname>
2>go
Now you can move the MDF and LDF files to new partition say D:\MSSQL\DATA
After that use the below command in the SQL prompt:-
1>sp_attach_db
'dbname','d:\mssql\data\dbname.mdf',''d:\mssql\data\dbname.ldf'
2>go
The above command will attach the database back to SQl Server but in new
partition.
Note: Do the above steps for all the other user databases as well as
Pubs,Northwind.
If you need to do the same for system databases (Master, model , tempdb,
msdb), follow the below link. The link also details movement of user
databases.
http://support.microsoft.com/defaul...;224071&sd=tech
Thanks
Hari
MCDBA
"Batista" <carlos.batista@.cmz.pt> wrote in message
news:ac3b01c43692$bc1bf350$a501280a@.phx.gbl...
> I have a server W2K (and MSDE) with 2 partitions one for
> system (3GB) and one for data (37GB).
> An application creates ALL SQL databases, in the default
> folder for MSDE 'c:\Program Files\Microsoft SQL
> Server\MSSQL\Data' in the system partition.
> It intended to move the databases for the data partition?
>

Move database to another partition

I have recently installed SQL Server 2005 Standard Edition on a server with 2
partitions. I then installed Sharepoint which installed a database and put it
in the default location on the c: partition. I would like to move this to d:.
I have tried to do this by detaching and attaching, and also by backing and
restoring, but both the attach and the backup dialog boxes only allow me to
browse the c: drive. Is this a feature of Standard Edition? Do I need to use
Enterprise? Or is there a configuration setting I can change somewhere?
TIA25degc wrote:
> I have recently installed SQL Server 2005 Standard Edition on a server with 2
> partitions. I then installed Sharepoint which installed a database and put it
> in the default location on the c: partition. I would like to move this to d:.
> I have tried to do this by detaching and attaching, and also by backing and
> restoring, but both the attach and the backup dialog boxes only allow me to
> browse the c: drive. Is this a feature of Standard Edition? Do I need to use
> Enterprise? Or is there a configuration setting I can change somewhere?
> TIA
Not sure why you can't browse your other drive, but a workaround would
be to not use the GUI to do this. Instead use the SQL commands to
detach/reattach the database:
EXEC sp_detach_db DBname, 'true'
Copy the files from C: to D:
EXEC sp_attach_db @.dbname = 'DBName', @.filename1 = 'D:\MDFFile',
@.filename2 = 'D:\LDFFile'|||Thanks. This highlighted an issue with the d: drive. Although
readable/writable through Windows I decided to reformat, and now it is
working fine.
Thanks for your help.
"Tracy McKibben" wrote:
> 25degc wrote:
> > I have recently installed SQL Server 2005 Standard Edition on a server with 2
> > partitions. I then installed Sharepoint which installed a database and put it
> > in the default location on the c: partition. I would like to move this to d:.
> > I have tried to do this by detaching and attaching, and also by backing and
> > restoring, but both the attach and the backup dialog boxes only allow me to
> > browse the c: drive. Is this a feature of Standard Edition? Do I need to use
> > Enterprise? Or is there a configuration setting I can change somewhere?
> >
> > TIA
> Not sure why you can't browse your other drive, but a workaround would
> be to not use the GUI to do this. Instead use the SQL commands to
> detach/reattach the database:
> EXEC sp_detach_db DBname, 'true'
> Copy the files from C: to D:
> EXEC sp_attach_db @.dbname = 'DBName', @.filename1 = 'D:\MDFFile',
> @.filename2 = 'D:\LDFFile'
>

Move database to another partition

25degc wrote:
> I have recently installed SQL Server 2005 Standard Edition on a server wit
h 2
> partitions. I then installed Sharepoint which installed a database and put
it
> in the default location on the c: partition. I would like to move this to
d:.
> I have tried to do this by detaching and attaching, and also by backing an
d
> restoring, but both the attach and the backup dialog boxes only allow me t
o
> browse the c: drive. Is this a feature of Standard Edition? Do I need to u
se
> Enterprise? Or is there a configuration setting I can change somewhere?
> TIA
Not sure why you can't browse your other drive, but a workaround would
be to not use the GUI to do this. Instead use the SQL commands to
detach/reattach the database:
EXEC sp_detach_db DBname, 'true'
Copy the files from C: to D:
EXEC sp_attach_db @.dbname = 'DBName', @.filename1 = 'D:\MDFFile',
@.filename2 = 'D:\LDFFile'I have recently installed SQL Server 2005 Standard Edition on a server with
2
partitions. I then installed Sharepoint which installed a database and put i
t
in the default location on the c: partition. I would like to move this to d:
.
I have tried to do this by detaching and attaching, and also by backing and
restoring, but both the attach and the backup dialog boxes only allow me to
browse the c: drive. Is this a feature of Standard Edition? Do I need to use
Enterprise? Or is there a configuration setting I can change somewhere?
TIA|||25degc wrote:
> I have recently installed SQL Server 2005 Standard Edition on a server wit
h 2
> partitions. I then installed Sharepoint which installed a database and put
it
> in the default location on the c: partition. I would like to move this to
d:.
> I have tried to do this by detaching and attaching, and also by backing an
d
> restoring, but both the attach and the backup dialog boxes only allow me t
o
> browse the c: drive. Is this a feature of Standard Edition? Do I need to u
se
> Enterprise? Or is there a configuration setting I can change somewhere?
> TIA
Not sure why you can't browse your other drive, but a workaround would
be to not use the GUI to do this. Instead use the SQL commands to
detach/reattach the database:
EXEC sp_detach_db DBname, 'true'
Copy the files from C: to D:
EXEC sp_attach_db @.dbname = 'DBName', @.filename1 = 'D:\MDFFile',
@.filename2 = 'D:\LDFFile'|||Thanks. This highlighted an issue with the d: drive. Although
readable/writable through Windows I decided to reformat, and now it is
working fine.
Thanks for your help.
"Tracy McKibben" wrote:

> 25degc wrote:
> Not sure why you can't browse your other drive, but a workaround would
> be to not use the GUI to do this. Instead use the SQL commands to
> detach/reattach the database:
> EXEC sp_detach_db DBname, 'true'
> Copy the files from C: to D:
> EXEC sp_attach_db @.dbname = 'DBName', @.filename1 = 'D:\MDFFile',
> @.filename2 = 'D:\LDFFile'
>|||Thanks. This highlighted an issue with the d: drive. Although
readable/writable through Windows I decided to reformat, and now it is
working fine.
Thanks for your help.
"Tracy McKibben" wrote:

> 25degc wrote:
> Not sure why you can't browse your other drive, but a workaround would
> be to not use the GUI to do this. Instead use the SQL commands to
> detach/reattach the database:
> EXEC sp_detach_db DBname, 'true'
> Copy the files from C: to D:
> EXEC sp_attach_db @.dbname = 'DBName', @.filename1 = 'D:\MDFFile',
> @.filename2 = 'D:\LDFFile'
>