MarkTO
MarkTO
Programming language:SQL
2021-05-14 08:07:10
0
Q:

sql server rename mdf file

Anonymous
Anonymous
Code: SQL
2021-07-17 04:15:35 
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
0

Tags

Related

New to Communities?

Join the community