![]() If you wish to move a data file, then you need to detach the database, move the data file, and reattach the db (see "sp_detach_db" in Books Online). You might want to create a folder called "Data" under "Inetpub" for the SQL data files that is not world-readable. They should not be accessible from any URL. I would highly recommend that you not put the mdf and ldf files anywhere in your web document tree. If you are creating the database in EM, look at the "Location" box in the "Data Files" or "Transaction Log" tabs of the "Database Properties" box. ![]() Please look at "CREATE DATABASE" in the books online. Though you can point a database to a different location when you create the database (either with Query Analyzer (QA) or Enterprise Manager (EM)). \Program Files\Microsoft SQL Server\MSSQL\Data, The default location for the database files is (I think), ![]() You connect to the server and select a database. SQL Server does not behave the same way as Access. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |