How to Rename Extention of MDF File?

Question

Sushant Mishra · Answer

CREATE DATABASE [mindstick]ON PRIMARY( NAME = N'[[mindstick]]', FILENAME = N'D:\mindstick.pdf' )LOG ON( NAME = N'[[mindstick]]_log', FILENAME = N'D:\mindstick.ldf')GO
and 
Next step is to take
database offline Click on taskandgt;offline
ALTER DATABASE [mindstick] MODIFY FILE (name = 'mindstick', and and and and and and and and and and and  filename
= 'D:\mindstick.mdf')GOand 
and 
Next step is to change
the name then take it online from offline

interview

How to Rename Extention of MDF File?

Sushant Mishra

Can you answer this question?

1 Answers

Liked By