1
Since sp_attach_single_file_db is deprecated and has been replaced with CREATE DATABASE..FOR ATTACH, let's try this to see if you have more luck.
USE [master]
GO
CREATE DATABASE [TestDB] ON
( FILENAME = N'E:\MSSQL\TestDBCopy.mdf' )
FOR ATTACH_REBUILD_LOG
GO
The Undocumented ATTACH_FORCE_REBUILD_LOG Command
By now we know that if we use the CREATE ...
Only top voted, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server-2005 × 1327sql-server × 819
sql-server-2008 × 149
performance × 113
backup × 56
t-sql × 54
sql-server-2008-r2 × 52
replication × 49
index × 48
sql-server-2012 × 42
stored-procedures × 35
restore × 31
transaction-log × 26
query-performance × 25
security × 24
database-design × 23
migration × 23
permissions × 20
linked-server × 19
mirroring × 19
tempdb × 19
sql-server-2000 × 18
deadlock × 17
maintenance × 17
ssis × 16