i'm hoping someone can help me out with this problem.
i have a database called Tracking.mdf and its associated logfile Tracking_log.ldf
i need to build another database based on the above with more tables and keep the data separate hence the requirement to make a copy of the tracking data file i've tried changing its name but it will not attach. i can change its database name to whatever i want but somehow can't find out how i can say change its actual filename to Tracker.mdf and Tracker_log.ldf
would someone be able to help me out. thanks.
hi,
please have a look at this article on how to move user's databases..
ALTER DATABASE syntax support both logical and physical rename of database and database's files..
regards
