| Allan Mitchell 2002-11-09, 4:23 am |
| Hmmmmm dangerous
In a SQL Server Backup you get the log and the dat file.
If you have only the mdf not the log for some reason and it wasn't
explicitly detached with sp_detach_db then you could struggle. Also have a
look at
sp_attach_single_file_db [ @dbname = ] 'dbname'
, [ @physname = ] 'physical_name'
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE, MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community for SQL Server
professionals - http://www.sqlpass.org
"Giovanni" <giovanni@giovannidavila.com> wrote in message
news:482501c287b5$21f7bf30$35e
f2ecf@TKMSFTNGXA11...
> If the database had only 1 transaction log then you can.
> SQL Server will recreate the log for you.
>
> >-----Original Message-----
> >
> >Can I attach (or restore from) a valid mdf file without
> the coresponding
> >log file? have serious corruption issues - anyinput will
> be greatly
> >appreciated.
> >
> >--
> >Posted via http://dbforums.com
> >.
> >
|