take a database from system databse place

[baran121]

Hi everyone,
I have a database in system database place. I dont know how i put it there, but this database is not a system database. how can i change it's place.
thanks.

 

[iambob]

Any program must be stopped to move item
Locate MDF and LDF Database

Files:
Database_name_Data.mdf - for .MDF
Database_name_log.ldf - for .LDF

Run this SQL script
ALTER DATABASE AnimalWorks
MODIFY FILE ( NAME = AnimalWorks_Data,
FILENAME = 'E:\New_location\AdventureWorks2014_Data.mdf');
GO

ALTER DATABASE AnimalWorks
MODIFY FILE ( NAME = AdventureWorks2014_Log,
FILENAME = 'E:\New_location\AdventureWorks2014_Log.ldf');
GO

This creates a separate drive with suffiecient disk space to store the file.

Did I solve your question or was that useless? Sorry, new to SQL.

 

[iambob]

Otherwise I don't know. I think the only way you can get it there is to create a new drive and transmit it through there?

Sincerely,
Bob Space