HAs any one backed up the log when data files are damaged? I am
following KB article Q253817. It is not working. When I run the backup
command , it gives mdf not exists in sql server 2000. Any one has
success?If you show us the BACKUP LOG command and the exact error message (including
error number etc) we can
hopefully comment. Easiest s to execute these commands from Query Analyzer a
nd not try to drive the UI in EM.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"tram" <tram_e@.hotmail.com> wrote in message news:26ee1067.0404010502.2f64ff17@.posting.goog
le.com...
> HAs any one backed up the log when data files are damaged? I am
> following KB article Q253817. It is not working. When I run the backup
> command , it gives mdf not exists in sql server 2000. Any one has
> success?|||Thanks for your reply. The first scenario was master was intcact, lost
the datafile of DB. Then the backup log with no_truncate worked
fine.(though it giving errors with MSDE version).
The second scenario, master was intact. The datafile of DB lost. I've
created another db and dropped both daat and log of newly created db.
Copy the crashed DB log to new DB as per KB article except using the
same master. When sql server starts up, that is making the new DB
offline. When run the backup log with no_truncate, it gives error.
Could not open FCB for invalid file ID 0 in database 'test1'
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<#
#mDbq#FEHA.3540@.TK2MSFTNGP09.phx.gbl>...
> If you show us the BACKUP LOG command and the exact error message (includi
ng error number etc) we can
> hopefully comment. Easiest s to execute these commands from Query Analyzer
and not try to drive the UI in EM.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "tram" <tram_e@.hotmail.com> wrote in message news:26ee1067.0404010502.2f64
ff17@.posting.google.com...
Showing posts with label crashed. Show all posts
Showing posts with label crashed. Show all posts
Thursday, February 16, 2012
Backup Llast log - Primary crashed
HAs any one backed up the log when data files are damaged? I am
following KB article Q253817. It is not working. When I run the backup
command , it gives mdf not exists in sql server 2000. Any one has
success?
If you show us the BACKUP LOG command and the exact error message (including error number etc) we can
hopefully comment. Easiest s to execute these commands from Query Analyzer and not try to drive the UI in EM.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"tram" <tram_e@.hotmail.com> wrote in message news:26ee1067.0404010502.2f64ff17@.posting.google.c om...
> HAs any one backed up the log when data files are damaged? I am
> following KB article Q253817. It is not working. When I run the backup
> command , it gives mdf not exists in sql server 2000. Any one has
> success?
|||Thanks for your reply. The first scenario was master was intcact, lost
the datafile of DB. Then the backup log with no_truncate worked
fine.(though it giving errors with MSDE version).
The second scenario, master was intact. The datafile of DB lost. I've
created another db and dropped both daat and log of newly created db.
Copy the crashed DB log to new DB as per KB article except using the
same master. When sql server starts up, that is making the new DB
offline. When run the backup log with no_truncate, it gives error.
Could not open FCB for invalid file ID 0 in database 'test1'
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<##mDbq#FEHA.3540@.TK2MSFTNGP09.phx.gbl>...
> If you show us the BACKUP LOG command and the exact error message (including error number etc) we can
> hopefully comment. Easiest s to execute these commands from Query Analyzer and not try to drive the UI in EM.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "tram" <tram_e@.hotmail.com> wrote in message news:26ee1067.0404010502.2f64ff17@.posting.google.c om...
following KB article Q253817. It is not working. When I run the backup
command , it gives mdf not exists in sql server 2000. Any one has
success?
If you show us the BACKUP LOG command and the exact error message (including error number etc) we can
hopefully comment. Easiest s to execute these commands from Query Analyzer and not try to drive the UI in EM.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"tram" <tram_e@.hotmail.com> wrote in message news:26ee1067.0404010502.2f64ff17@.posting.google.c om...
> HAs any one backed up the log when data files are damaged? I am
> following KB article Q253817. It is not working. When I run the backup
> command , it gives mdf not exists in sql server 2000. Any one has
> success?
|||Thanks for your reply. The first scenario was master was intcact, lost
the datafile of DB. Then the backup log with no_truncate worked
fine.(though it giving errors with MSDE version).
The second scenario, master was intact. The datafile of DB lost. I've
created another db and dropped both daat and log of newly created db.
Copy the crashed DB log to new DB as per KB article except using the
same master. When sql server starts up, that is making the new DB
offline. When run the backup log with no_truncate, it gives error.
Could not open FCB for invalid file ID 0 in database 'test1'
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<##mDbq#FEHA.3540@.TK2MSFTNGP09.phx.gbl>...
> If you show us the BACKUP LOG command and the exact error message (including error number etc) we can
> hopefully comment. Easiest s to execute these commands from Query Analyzer and not try to drive the UI in EM.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "tram" <tram_e@.hotmail.com> wrote in message news:26ee1067.0404010502.2f64ff17@.posting.google.c om...
Friday, February 10, 2012
Backup Followed by Crash
Hi. I have a SQL Server 2000 server that runs backups
every night on a handful of not very active databases.
Recently, the server has crashed or hung each time,
following successful backup of all but the last database.
No error message, no warning. The system log shows a
successful completion of the next-to-last backup. About
six seconds later (usually) there is a system time stamp
in the security log. Then the system just checks out,
sometimes powered down, sometimes hung but still powered
on. I have to manually reboot the system.
Any suggestions on how to track down the problem?
Thanks!
Nora Miller
Portland OR
NMiller,
What's in your
* SQL Server error log
* Windows Appication event log
* Windows System event log
Post relevant entries here. Do you have enough disk space? Where are you
backing up to? It could be a driver problem if using a tape device.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
NMiller wrote:
> Hi. I have a SQL Server 2000 server that runs backups
> every night on a handful of not very active databases.
> Recently, the server has crashed or hung each time,
> following successful backup of all but the last database.
> No error message, no warning. The system log shows a
> successful completion of the next-to-last backup. About
> six seconds later (usually) there is a system time stamp
> in the security log. Then the system just checks out,
> sometimes powered down, sometimes hung but still powered
> on. I have to manually reboot the system.
> Any suggestions on how to track down the problem?
> Thanks!
> Nora Miller
> Portland OR
every night on a handful of not very active databases.
Recently, the server has crashed or hung each time,
following successful backup of all but the last database.
No error message, no warning. The system log shows a
successful completion of the next-to-last backup. About
six seconds later (usually) there is a system time stamp
in the security log. Then the system just checks out,
sometimes powered down, sometimes hung but still powered
on. I have to manually reboot the system.
Any suggestions on how to track down the problem?
Thanks!
Nora Miller
Portland OR
NMiller,
What's in your
* SQL Server error log
* Windows Appication event log
* Windows System event log
Post relevant entries here. Do you have enough disk space? Where are you
backing up to? It could be a driver problem if using a tape device.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
NMiller wrote:
> Hi. I have a SQL Server 2000 server that runs backups
> every night on a handful of not very active databases.
> Recently, the server has crashed or hung each time,
> following successful backup of all but the last database.
> No error message, no warning. The system log shows a
> successful completion of the next-to-last backup. About
> six seconds later (usually) there is a system time stamp
> in the security log. Then the system just checks out,
> sometimes powered down, sometimes hung but still powered
> on. I have to manually reboot the system.
> Any suggestions on how to track down the problem?
> Thanks!
> Nora Miller
> Portland OR
Subscribe to:
Posts (Atom)