Sql server rename mdf file

This article is tagged with: Sql server rename mdf file and mysql

sql server rename mdf file

USE [master];
GO
ALTER DATABASE QuestelServicesDirectValidation_ORIG SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE QuestelServicesDirectValidation_ORIG SET OFFLINE
GO
ALTER DATABASE QuestelServicesDirectValidation_ORIG MODIFY FILE (Name='QuestelServicesDirectValidation_ORIG', FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\QuestelServicesDirectValidation_ORIG.mdf')
GO
ALTER DATABASE QuestelServicesDirectValidation_ORIG MODIFY FILE (Name='QuestelServicesDirectValidation_ORIG_log', FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\QuestelServicesDirectValidation_ORIG_log.ldf')
GO
ALTER DATABASE QuestelServicesDirectValidation_ORIG SET ONLINE
GO
ALTER DATABASE QuestelServicesDirectValidation_ORIG SET MULTI_USER
GO

This article is tagged with: Sql server rename mdf file and mysql