Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating database with mdf and ldf file.
- Thread starter DonS100
- Start date
Attach the database, then delete all the records from all the tables and you have a blank database.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
What do you mean by "create a new database"?
A database can be detached, then the .mdf and .ldf (and any .ndf) files can be copied, moved to a new location and attached. But that doesn't create a 'new database', it only creates a copy of the original.
-SQLBill
Posting advice: FAQ481-4875
A database can be detached, then the .mdf and .ldf (and any .ndf) files can be copied, moved to a new location and attached. But that doesn't create a 'new database', it only creates a copy of the original.
-SQLBill
Posting advice: FAQ481-4875
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question