Re: To recover corrupted database

Soura,
if you're using simple recovery mode then you can't have been backing up the
transaction logs, so the full database backups will be the only useful ones
here. There are some procedures to help fix certain suspect/corrupt problems
such as DBCC CHECKDB and a step-by-step approach is outlined on Tibor's
site: http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


.

Relevant Pages

  • Is this even possible?
    ... I have a very strange problem and just wanted to run something with ... (The flat file is there however, which means a select must have taken ... We have performed a backup and rollforward using the transaction logs ... SQL server setup causing problems or determining that changes aret ...
    (microsoft.public.sqlserver.setup)
  • Re: Huge data needs to be transfer from Fixed width Text File to S
    ... 1- Transform the data, because I have to change data into Date and money from Char and I need to perform certain validation which is very hard to implement in TQSL as i am using SQL Server 2000. ... This can *really* save you time (and transaction logs size) on big data import operations, as it makes the DB log only the whole operation in the transaction logs, as opposed to logging every single row inserted. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQLServer cant backup remotely (on Workgroups) unless Administrator?
    ... I removed SQLAgent from the equation by backing up directly from Query ... > SQL Server Agent must be started under stronger account, ... >>SQL backup across the network to an NT Server. ...
    (microsoft.public.sqlserver.security)
  • Re: Using BLOB
    ... network 'store' and restore the transaction logs periodically on the ... backup and restore time. ... It goes without saying that the more data you store in the database, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Getting Phone to stay on!
    ... Try backing up your system and doing a hard reset ... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ...
    (microsoft.public.pocketpc.phone_edition)