Is there a way to read a backup file to see if it contains a file without
restoring the backup file? We are missing a record from a table, and I need
to find out when it was deleted. We have nightly backup files of the
database. Is it possible, knowing the database name, the table name, and the
primary key value of the record, to determine if the record exists in a
certain backup file? If not, is there an alternate way to determine when a
particular record was deleted?
Thank you!
Neil 2 2451
Neil (no****@nospam.net) writes:
Is there a way to read a backup file to see if it contains a file
without restoring the backup file?
You can use RESTORE FILELISTONLY to list the backups within a backup file.
We are missing a record from a table, and I need to find out when it was
deleted. We have nightly backup files of the database. Is it possible,
knowing the database name, the table name, and the primary key value of
the record, to determine if the record exists in a certain backup file?
You need to restore the backup. But you could restore it under a different
name.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
Right. I was just that, if I wanted to find out *when* it was deleted, I'd
have to restore the backups one at a time, and look at the database after
each restore to see if it were there.
Thanks,
Neil
"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...
Neil (no****@nospam.net) writes:
>Is there a way to read a backup file to see if it contains a file without restoring the backup file?
You can use RESTORE FILELISTONLY to list the backups within a backup file.
>We are missing a record from a table, and I need to find out when it was deleted. We have nightly backup files of the database. Is it possible, knowing the database name, the table name, and the primary key value of the record, to determine if the record exists in a certain backup file?
You need to restore the backup. But you could restore it under a different
name.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: nt |
last post by:
I am having a problem with a regular backup of an SQL Server (MSDE
2000) database to a local drive. I initiate the backup once a week, by
issuing the required T-SQL, via ADO. In this case, the...
|
by: Jason |
last post by:
In SQL 2000, is there an advantage to defining and using a backup
device versus just backing up to disk?
Currently, I've got a SQL Backup job set to run once per day, with
transaction log...
|
by: tgru |
last post by:
I am using log shipping. I want to be able to backup the secondary
read-only database. The data has to travel over a t1, and due to the
size of the databases, it saturates the network. Our tape...
|
by: tgru |
last post by:
Hello,
Can anyone tell me how to backup read-only databases? I want to backup
the secondary databases in my log shipping pairs.
Thanks,
TGru
*** Sent via Developersdex...
|
by: Stanley Sinclair |
last post by:
I just brought a new small server online. It has two disks in RAID1
(mirrored) for the operating system and logs and DB2 DBMS. DB2 data
on a separate RAID 5EE array on four disks. (IBM ServeRAID...
|
by: Dave Coate |
last post by:
Hello again,
I am going to re-post a question. I got some excellent suggestions from
Rob and Mattias on this but their ideas did not solve the problem. Here is
the original post:
...
|
by: pjbr34 |
last post by:
Hi everyone,
I am running DB2 8.2 under SuSE SLES9 (zSeries).
My current problem is when trying to make a direct backup to tape.
- I can make a DB2 backup to a filesystem and it works fine....
|
by: Zenek |
last post by:
Hello,
I have:
- server MS SQL MSDE (2000)
- database 'COLLBASE'
- table 'MAIN'
- row: column 'NAME' value 'version' and column 'VALUE' value '003'
I make backup files by SQL query.
|
by: gavino |
last post by:
This seems easy but I have been asking tcl and python IRC chat all day
and no one gave an answer.
I have 100 servers which need a new backup server added to a text file,
and then the backup...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |