Перенос файлов базы данных tempdb на сервере MSSQL
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
USE master GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'F:\SQL_tempdb\tempdb.mdf') GO ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'F:\SQL_tempdb\templog.ldf') GO ALTER DATABASE tempdb MODIFY FILE (NAME = temp2, FILENAME = 'F:\SQL_tempdb\tempdb_mssql_2.ndf') GO ALTER DATABASE tempdb MODIFY FILE (NAME = temp3, FILENAME = 'F:\SQL_tempdb\tempdb_mssql_3.ndf') GO ALTER DATABASE tempdb MODIFY FILE (NAME = temp4, FILENAME = 'F:\SQL_tempdb\tempdb_mssql_4.ndf') GO ALTER DATABASE tempdb MODIFY FILE (NAME = temp5, FILENAME = 'F:\SQL_tempdb\tempdb_mssql_5.ndf') GO ALTER DATABASE tempdb MODIFY FILE (NAME = temp6, FILENAME = 'F:\SQL_tempdb\tempdb_mssql_6.ndf') GO |
Категории: 1С Предприятие 8.2
