Home Forums SQL Server 7,2000 Administration Restore Database from MDF file without LDF RE: Restore Database from MDF file without LDF
SanjayAttray
SSChampion
Points: 13157
More actions
February 8, 2008 at 12:56 pm
#776565
try this.
sp_attach_single_file_db @dbname= 'dbname' ,@physname= 'physical_name'
but, make sure database got only one .mdf file or say datafile. This command doesnot work with multiple data files.
SQL DBA.