Log Backup

Hi,
I read in a book that when a database becomes suspected, the first thing to
do is backing up the log file. I tried to simulate suspecting but I could
not backup the log file( I deleted a NDF file):
Server: Msg 945, Level 14, State 2, Line 3
Database 'Northwind' cannot be opened due to inaccessible files or
insufficient memory or disk space. See the SQL Server errorlog for details.
Server: Msg 3013, Level 16, State 1, Line 3
BACKUP LOG is terminating abnormally.
What's the solution if I want to keep my data in such situations?
Thanks in advance,
Leila
Have a look at this:
http://support.microsoft.com/kb/253817/EN-US/
Andrew J. Kelly SQL MVP
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23UQdQr7tFHA.2160@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I read in a book that when a database becomes suspected, the first thing
> to
> do is backing up the log file. I tried to simulate suspecting but I could
> not backup the log file( I deleted a NDF file):
> --
> Server: Msg 945, Level 14, State 2, Line 3
> Database 'Northwind' cannot be opened due to inaccessible files or
> insufficient memory or disk space. See the SQL Server errorlog for
> details.
> Server: Msg 3013, Level 16, State 1, Line 3
> BACKUP LOG is terminating abnormally.
> --
> What's the solution if I want to keep my data in such situations?
> Thanks in advance,
> Leila
>
|||Thanks Andrew,
But I cannot rename the log file of suspected database.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eMta6q$tFHA.3628@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Have a look at this:
> http://support.microsoft.com/kb/253817/EN-US/
>
> --
> Andrew J. Kelly SQL MVP
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23UQdQr7tFHA.2160@.TK2MSFTNGP10.phx.gbl...
could
>