INFORMATICS

Aby zmienić lokalizację plików bazodanowych w MSSQL możemy wykonać to za pomocą polecenia:

use master;
GO
ALTER DATABASE model
MODIFY FILE (NAME = modeldev,FILENAME = 'F:\Microsoft SQL Server-\MSSQL10.MSSQLSERVER\MSSQL\DATA\model.mdf');
GO
ALTER DATABASE model
MODIFY FILE (NAME = Modellog,FILENAME = 'F:\Microsoft SQL Server-\MSSQL10.MSSQLSERVER\MSSQL\DATA\modelLog.ldf');
GO

use master;
GO
ALTER DATABASE msdb
MODIFY FILE (NAME = MSDBData,FILENAME = 'F:\Microsoft SQL Server-\MSSQL10.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf');
GO
ALTER DATABASE msdb
MODIFY FILE (NAME = MSDBLog,FILENAME = 'F:\Microsoft SQL Server-\MSSQL10.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf');
GO

use master;
GO
ALTER DATABASE tempdb

MODIFY FILE (NAME = tempdev,FILENAME = 'F:\Microsoft SQL Server-\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdf');
GO
ALTER DATABASE tempdb

MODIFY FILE (NAME = templog,FILENAME = 'F:\Microsoft SQL Server-\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempLog.ldf');
GO

Przykład ten zmienia lokalizację plików bazodanowych z 'C:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA na 'F:\Microsoft SQL Server-\MSSQL10.MSSQLSERVER\MSSQL\DATA