Hi, i use sql server 2005 express where i created several databases. When opening Management Studio, i can see, besides my databases, also Master, Model etc .. which manage the databases. Now i also use MDF files which are disseminated on the same server. I see that for one given user, there is also a Master, Model etc ... in c:\document and settings\that user\ ....
My question is: are those local Master, Model etc ... related with the central Master, Model ... of the central database system or are they independant? What if i delete the MDF files and its related system files in c:\.doc and settings\.. ?
Thanks
When you check under properties for the database in the Management Studio you should see the database is pointing to a particular file on the drives. So other than this MDF file you could delete any other MDF files with same name if you are sure no one else is using the files. You could try moving the files to a different location and if it lets you do it then no one is using it. If the files are being used you would get an '..Access violation..' or ' file in use..' error.
|||thanks
No comments:
Post a Comment