Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to Rename Extention of MDF File?

Sushant Mishra 1847 18 Sep 2017

1 Answers

Sushant Mishra 18 Sep 2017

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

Next step is to take database offline Click on task>offline

ALTER DATABASE [mindstick] 
MODIFY FILE (name = 'mindstick', 
            filename
= 'D:\mindstick.mdf')
GO

Next step is to change the name then take it online from offline

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.