1 Topic by JN

  • JN
  • Member
  • Offline
  • From: Jakarta
  • Registered: 2009-10-26
  • Posts: 59

Topic: Single Attach database with no transaction log

Single attach database is use for database that just have one file (mdf), When the data file will be attached, SQL Server will create a new transaction log file automatically.

Query for single attach :
EXEC sp_attach_single_file_db <database_name> , <physical file of the database (mdf)>