I asked how to apply the latest log when DB is crashed.
Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE option"
But if both .mdf and .ldf are not avaible.what to do..
Informix way of backup
1)automaticaly backup its log when the log is full,(instead of based on
schedule)
2)backup its log when the server is crashed.
I hope Sql-server can handle it this way.is it possible?
Thanks!If the server has crashed how could it reliably make a backup? If you have
lost your disks or files, then you have no option but to go to a tape (or
other remote location) for a backup file(s). Which is why it is so
important to use a fault tolerant disk subsystem.
If you haven't lost the files, then you should be able to make a backup of
the log using the NO_TRUNCATE option and then use that backup and any
previous log backup files to recover to the point of the crash.
"Straight" <someone@.> wrote in message
news:uUjm5sMLEHA.340@.TK2MSFTNGP11.phx.gbl...
> I asked how to apply the latest log when DB is crashed.
> Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE option"
> But if both .mdf and .ldf are not avaible.what to do..
> Informix way of backup
> 1)automaticaly backup its log when the log is full,(instead of based on
> schedule)
> 2)backup its log when the server is crashed.
> I hope Sql-server can handle it this way.is it possible?
> Thanks!
>|||If i split .mdf and .ldf on diffrent disks.
.mdf was damaged ,.ldf was fine
I restore the latest DB backup ,can i rollfoward with the intact .ldf on the
diffrent good disk ?.
How ?because i found £¢backup log with no_truncate£¢ is impossible while the
DB is not running.
Thank you!
"Don Peterson" <no1@.nunya.com> дÈëÓʼþ
news:ezcF34MLEHA.1120@.TK2MSFTNGP11.phx.gbl...
> If the server has crashed how could it reliably make a backup? If you
have
> lost your disks or files, then you have no option but to go to a tape (or
> other remote location) for a backup file(s). Which is why it is so
> important to use a fault tolerant disk subsystem.
> If you haven't lost the files, then you should be able to make a backup of
> the log using the NO_TRUNCATE option and then use that backup and any
> previous log backup files to recover to the point of the crash.
> "Straight" <someone@.> wrote in message
> news:uUjm5sMLEHA.340@.TK2MSFTNGP11.phx.gbl...
> > I asked how to apply the latest log when DB is crashed.
> > Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE
option"
> > But if both .mdf and .ldf are not avaible.what to do..
> >
> > Informix way of backup
> > 1)automaticaly backup its log when the log is full,(instead of based on
> > schedule)
> > 2)backup its log when the server is crashed.
> >
> > I hope Sql-server can handle it this way.is it possible?
> >
> > Thanks!
> >
> >
>|||Backup log with no truncate behaves correctly at sql server 2000, in as =much as you can back up the lock even when the mdf is unavailable. =(provided you are in full recovery model - in bulk logged the mdf will =be required if any statements that operate in minimally_logged mode have =occured since the changes for these will need to be extracted by using =the bulk-change-map from the mdf). At 7 the primary filegroup mdf was =also required since the table sysfiles was stored there which has =details of what files make up the db - this was modified at 2000 by =introducing sysaltfiles in the master db to shadow the contents of =sysfiles.
So - backup log with no truncate WILL be fine provided one of master or =the primary mdf is available. To ensure this put master on different =drive to user databases, and put logs on raid 1 so at least one copy of =the log will survive a disc failure, (Logs on separate spindle to mdf as =well of course)
Mike John
"Straight" <someone@.> wrote in message =news:eS0FB4OLEHA.1192@.TK2MSFTNGP11.phx.gbl...
> If i split .mdf and .ldf on diffrent disks.
> .mdf was damaged ,.ldf was fine
> I restore the latest DB backup ,can i rollfoward with the intact .ldf =on the
> diffrent good disk ?.
> > How ?because i found =A3=A2backup log with no_truncate=A3=A2 is =impossible while the
> DB is not running.
> > Thank you!
> > > > "Don Peterson" <no1@.nunya.com> =D0=B4=C8=EB=D3=CA=BC=FE
> news:ezcF34MLEHA.1120@.TK2MSFTNGP11.phx.gbl...
> > If the server has crashed how could it reliably make a backup? If =you
> have
> > lost your disks or files, then you have no option but to go to a =tape (or
> > other remote location) for a backup file(s). Which is why it is so
> > important to use a fault tolerant disk subsystem.
> >
> > If you haven't lost the files, then you should be able to make a =backup of
> > the log using the NO_TRUNCATE option and then use that backup and =any
> > previous log backup files to recover to the point of the crash.
> >
> > "Straight" <someone@.> wrote in message
> > news:uUjm5sMLEHA.340@.TK2MSFTNGP11.phx.gbl...
> > > I asked how to apply the latest log when DB is crashed.
> > > Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE
> option"
> > > But if both .mdf and .ldf are not avaible.what to do..
> > >
> > > Informix way of backup
> > > 1)automaticaly backup its log when the log is full,(instead of =based on
> > > schedule)
> > > 2)backup its log when the server is crashed.
> > >
> > > I hope Sql-server can handle it this way.is it possible?
> > >
> > > Thanks!
> > >
> > >
> >
> >
> >|||Also, if the whole SQL Server goes down (cannot start it), then you can still get up to minute recovery. You
take another SQL Server installation, create a database with same file structure. Stop that SQL Server. Delete
the database file. Then "slide" in the log file from the crashed SQL Server, and then do the log backup using
the no_truncate option. There's a KB on this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Mike John" <Mike.John@.knowledgepool.spamtrap.com> wrote in message
news:e5yHLTPLEHA.2260@.TK2MSFTNGP09.phx.gbl...
Backup log with no truncate behaves correctly at sql server 2000, in as much as you can back up the lock even
when the mdf is unavailable. (provided you are in full recovery model - in bulk logged the mdf will be
required if any statements that operate in minimally_logged mode have occured since the changes for these will
need to be extracted by using the bulk-change-map from the mdf). At 7 the primary filegroup mdf was also
required since the table sysfiles was stored there which has details of what files make up the db - this was
modified at 2000 by introducing sysaltfiles in the master db to shadow the contents of sysfiles.
So - backup log with no truncate WILL be fine provided one of master or the primary mdf is available. To
ensure this put master on different drive to user databases, and put logs on raid 1 so at least one copy of
the log will survive a disc failure, (Logs on separate spindle to mdf as well of course)
Mike John
"Straight" <someone@.> wrote in message news:eS0FB4OLEHA.1192@.TK2MSFTNGP11.phx.gbl...
> If i split .mdf and .ldf on diffrent disks.
> .mdf was damaged ,.ldf was fine
> I restore the latest DB backup ,can i rollfoward with the intact .ldf on the
> diffrent good disk ?.
> How ?because i found £¢backup log with no_truncate£¢ is impossible while the
> DB is not running.
> Thank you!
>
> "Don Peterson" <no1@.nunya.com> дÈëÓʼþ
> news:ezcF34MLEHA.1120@.TK2MSFTNGP11.phx.gbl...
> > If the server has crashed how could it reliably make a backup? If you
> have
> > lost your disks or files, then you have no option but to go to a tape (or
> > other remote location) for a backup file(s). Which is why it is so
> > important to use a fault tolerant disk subsystem.
> >
> > If you haven't lost the files, then you should be able to make a backup of
> > the log using the NO_TRUNCATE option and then use that backup and any
> > previous log backup files to recover to the point of the crash.
> >
> > "Straight" <someone@.> wrote in message
> > news:uUjm5sMLEHA.340@.TK2MSFTNGP11.phx.gbl...
> > > I asked how to apply the latest log when DB is crashed.
> > > Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE
> option"
> > > But if both .mdf and .ldf are not avaible.what to do..
> > >
> > > Informix way of backup
> > > 1)automaticaly backup its log when the log is full,(instead of based on
> > > schedule)
> > > 2)backup its log when the server is crashed.
> > >
> > > I hope Sql-server can handle it this way.is it possible?
> > >
> > > Thanks!
> > >
> > >
> >
> >
>
-1073548784) Executing the query "BACKUP DATABASE [SURVIAC] TO DISK = N'C:\\DatabaseBackups\\DailyFull\\SURVIAC\\SURVIAC_backup_200707091051.bak' WITH NOFORMAT, NOINIT, NAME = N'SURVIAC_backup_20070709105151', SKIP, REWIND, NOUNLOAD, STATS = 10