-
Notifications
You must be signed in to change notification settings - Fork 0
/
MovingSystemBasesToTheDifferentLocation.sql
13 lines (13 loc) · 1.23 KB
/
MovingSystemBasesToTheDifferentLocation.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
ALTER DATABASE model MODIFY FILE ( NAME = modeldev , FILENAME = 'H:\BASES\DATA\model.mdf' )
ALTER DATABASE model MODIFY FILE ( NAME = modellog , FILENAME = 'H:\BASES\DATA\modellog.ldf' )
ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBData , FILENAME = 'H:\BASES\DATA\MSDBData.mdf' )
ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBLog, FILENAME = 'H:\BASES\DATA\MSDBLog.ldf' )
ALTER DATABASE tempdb MODIFY FILE ( NAME = tempdev , FILENAME = 'H:\BASES\DATA\tempdb.mdf' )
ALTER DATABASE tempdb MODIFY FILE ( NAME = templog , FILENAME = 'H:\BASES\DATA\templog.ldf' )
ALTER DATABASE tenpdb MODIFY FILE ( NAME = temp2 , FILENAME = 'H:\BASES\DATA\tempdb_mssql_2.ndf' )
ALTER DATABASE tenpdb MODIFY FILE ( NAME = temp3 , FILENAME = 'H:\BASES\DATA\tempdb_mssql_3.ndf' )
ALTER DATABASE tenpdb MODIFY FILE ( NAME = temp4 , FILENAME = 'H:\BASES\DATA\tempdb_mssql_4.ndf' )
ALTER DATABASE tenpdb MODIFY FILE ( NAME = temp5 , FILENAME = 'H:\BASES\DATA\tempdb_mssql_5.ndf' )
ALTER DATABASE tenpdb MODIFY FILE ( NAME = temp6 , FILENAME = 'H:\BASES\DATA\tempdb_mssql_6.ndf' )
ALTER DATABASE tenpdb MODIFY FILE ( NAME = temp7 , FILENAME = 'H:\BASES\DATA\tempdb_mssql_7.ndf' )
ALTER DATABASE tenpdb MODIFY FILE ( NAME = temp8 , FILENAME = 'H:\BASES\DATA\tempdb_mssql_8.ndf' )