Déplacement de la DB Master
Bonjour,
J'ai essayé de déplacer la base master sur une autre partition:
Localisation:
Code:
1
2
3
4
5
6
7
| SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('master');
name physical_name
master C:\Program Files\Microsoft SQL Server\MSSQL\DATA\master.mdf
mastlog C:\Program Files\Microsoft SQL Server\MSSQL\DATA\mastlog.ldf |
Déplacement de fichiers:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
| ALTER DATABASE MASTER
MODIFY FILE ( NAME = MASTER, FILENAME = "G:\SQLSYS\MASTER.mdf")
GO
The file "master" has been modified in the system catalog. The new path will be used the next time the database is started.
ALTER DATABASE MASTER
MODIFY FILE ( NAME = MASTLOG, FILENAME = "E:\SQLSYS\MASTLOG.ldf")
GO
The file "MASTLOG" has been modified in the system catalog. The new path will be used the next time the database is started. |
Vérification:
Code:
1
2
3
4
5
6
7
| SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('master');
name physical_name
master E:\SQLSYS\MASTER.mdf
mastlog E:\SQLSYS\MASTLOG.ldf |
Après le redémarrage de service SQL:
S
Code:
1
2
3
4
5
6
7
| ELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('master');
name physical_name
master C:\Program Files\Microsoft SQL Server\MSSQL\DATA\master.mdf
mastlog C:\Program Files\Microsoft SQL Server\MSSQL\DATA\mastlog.ldf |
Je reviens à l'état initial !!!
Est ce qu'il d'autes opérations à faire pour que le changement ait lieu ?
Merci.
@+
