|
-
you can solve this issue by using T-SQL :
CREATE DATABASE [YourDatabaseName] ON
(FILENAME = 'C:\123\YourDatabaseName.mdf')
FOR ATTACH_REBUILD_LOG ;
Or, you can also use a stored procedure:
EXEC sp_attach_single_file_db @dbname=' YourDatabaseName',
@physname=N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQL \MSSQL\DATA\ YourDatabaseName.mdf'
GO
If a single log file is missing.
Good Luck!
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|