extend disk lvm linux
- 3 Comments
- Dec, 09, 2009
- Angelo Schalley
- Linux
fdisk /dev/sdb
create as many partitions as you need using command n
Label them with command t as 8e for making it Linux LVM
Write and Exit with the command w.
Format the partitions you require using mkfs command
Read more on extend disk lvm linux…
list the physical disk layout on linux
- No Comments
- Dec, 09, 2009
- Angelo Schalley
- Linux
fdisk -l
moving tempdb Microsoft SQl server 2000 2005
- No Comments
- Dec, 01, 2009
- Angelo Schalley
- MS SQL
check to see what the setting is right now :
USE tempdb
GO
EXEC sp_helpfile
GO
after checking, change the location acording
USE master
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = ‘D:\tempdb.mdf’)
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = ‘D:\templog.ldf’)
GO
Read more on moving tempdb Microsoft SQl server 2000 2005…
Categories
