predetermine size of differential

is it possible to interrogate the differential page map prior to making
a backup? I'm interested in logic that will determine if the diff is
approaching the size of the entire database (in order to just do a full
and cut down on subsequent diff's..)
Thanks in advance.
You can try with the undocumented DBCC PAGE command - see
http://www.winnetmag.com/Article/Art...097/8097.html.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
<SNVPCUXCTYJD@.spammotel.com> wrote in message
news:1105288921.999780.38360@.c13g2000cwb.googlegro ups.com...
> is it possible to interrogate the differential page map prior to making
> a backup? I'm interested in logic that will determine if the diff is
> approaching the size of the entire database (in order to just do a full
> and cut down on subsequent diff's..)
>
> Thanks in advance.
>

predetermine size of differential

is it possible to interrogate the differential page map prior to making
a backup? I'm interested in logic that will determine if the diff is
approaching the size of the entire database (in order to just do a full
and cut down on subsequent diff's..)
Thanks in advance.You can try with the undocumented DBCC PAGE command - see
http://www.winnetmag.com/Article/ArticleID/8097/8097.html.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
<SNVPCUXCTYJD@.spammotel.com> wrote in message
news:1105288921.999780.38360@.c13g2000cwb.googlegroups.com...
> is it possible to interrogate the differential page map prior to making
> a backup? I'm interested in logic that will determine if the diff is
> approaching the size of the entire database (in order to just do a full
> and cut down on subsequent diff's..)
>
> Thanks in advance.
>

predetermine size of differential

is it possible to interrogate the differential page map prior to making
a backup? I'm interested in logic that will determine if the diff is
approaching the size of the entire database (in order to just do a full
and cut down on subsequent diff's..)
Thanks in advance.You can try with the undocumented DBCC PAGE command - see
http://www.winnetmag.com/Article/Ar...8097/8097.html.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
<SNVPCUXCTYJD@.spammotel.com> wrote in message
news:1105288921.999780.38360@.c13g2000cwb.googlegroups.com...
> is it possible to interrogate the differential page map prior to making
> a backup? I'm interested in logic that will determine if the diff is
> approaching the size of the entire database (in order to just do a full
> and cut down on subsequent diff's..)
>
> Thanks in advance.
>

Prdida de datos de una tabla sin backup

Tengo un problema ya que he perdido los datos de una tabla de mi base de datos. el problema es que no hice backup de la base de datos y al utilizar recovery me pide un backup para poder recuperar los datos perdidos, lo unico que tengo es el registro de transacciones.
Quisiera saber si puedo recuperar mi informacin con el registro de transacciones, y si hay alguna manera de editarlo para borrar la sentencia delete que origin la perdida de mi informacin
GraciasI am guessing at the translation here, but I think you have a table that got deleted by accident, and there is no (usable) backup of the database? It also looks like you may have a transaction log to work with. Can you run the following command and post the results to confirm you are in full recovery mode?

exec sp_dboption 'base de datos name'|||Google translation

I have a problem since there are lost the data of a table of my data base. the problem is that I did not do backup of the data base and when using recovery requests backup to me to be able to recover the lost data, the unico that I have is the registry of transactions. It wanted to know if I can recover my information with the registry of transactions, and if delete is some way to publish it to erase the sentence that originated lost of my information Thanks|||Here's a shot:

No sepa bien esto traducir, pero mire para arriba a explorador del registro de Lumigent. * Leer sus registros de la transaccin y permitir que usted recupere sus datos. Y comienzo del immediatley que sostiene sus datos. Buena Suerte

* GOOGLE "Lumigent Log Explorer"|||This does not know well will translate, but it watches for above explorer of the registry of Lumigent. * It will read its registries of the transaction and will allow that you recover your data. And beginning of the immediatley that maintains its data. Good Luck

What were you trying to say Brett ;) ?|||That's how it translated back?

sheesh

Originally

Don't know how well this will translate, but look up Lumigent Log Explorer. It will read your transaction logs and allow you to recover your data. And immediatley start backing up your data. Good Luck

I thought it did a good job going from Spanish to English though...|||Yes, the database is in full recovery mode, but I set it after my data was deleted.
I've read about Log Explorer and I've downloaded the test version but it don't let me to use my own database. Does I need to buy it? How much it cost?|||I am afraid if there is no full backup from the time before the data was deleted, then the data can not be restored.|||Rename Northwind to Northwind_Original, and rename your database to Northwind. But I think MCrowley pretty much nailed it, unless we all miss something.

Post Hotfix error

I am getting the following (MOM) error on 3 of my databases anytime I initiate a backup of the mdf. The database seems to backup as expected. The one thing that has recently changed is I implemented MS Hotfix 2187 on my SQl cluster over the weekend.

Severity: Critical Error

Status: New

Source: MSSQLSERVER

Name: Commit record has already been distributed. Check DBTABLE

Description: Unable to expand message 17055 [-1073724769] 18264 Database backed up: Database: XX03PLUS, creation date(time): 2005/12/06(18:38:50), pages dumped: 23026, first LSN: 18761:44:1, last LSN: 18761:46:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'G:\temp\ar03PLUS_fromVCforK1.bak'}).

thanks in advance,

Jerry

I thought I would reply to my own post as I have remediated the error in case someone else ever has this issue.

AS it turns out the Hotfix 'upgrade' can create orphaned users and or users with 'not as expected' permissions. By deinstalling (detaching) and reinstalling (re-attaching) via an internal script that also reassigned appropriate users and permissions I wa able to clean up the errors.

best of luck,

Jerry

Possible to undo a restore operation?

I just restored a db from its full backup and then applied its diff backup
and a log backup. Now I need to know how the db looked like before the log
backup was applied. Is it possible to undo the restore from the log backup?
Thanks,
BingNope. You will have to redo the restore and stop one step earlier.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bing" <bing@.discussions.microsoft.com> wrote in message
news:F9861F7C-1D50-40C7-8B83-3ECCDC838AD8@.microsoft.com...
> I just restored a db from its full backup and then applied its diff backup
> and a log backup. Now I need to know how the db looked like before the
log
> backup was applied. Is it possible to undo the restore from the log
backup?
> Thanks,
> Bing

Possible to undo a restore operation?

I just restored a db from its full backup and then applied its diff backup
and a log backup. Now I need to know how the db looked like before the log
backup was applied. Is it possible to undo the restore from the log backup?
Thanks,
Bing
Nope. You will have to redo the restore and stop one step earlier.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bing" <bing@.discussions.microsoft.com> wrote in message
news:F9861F7C-1D50-40C7-8B83-3ECCDC838AD8@.microsoft.com...
> I just restored a db from its full backup and then applied its diff backup
> and a log backup. Now I need to know how the db looked like before the
log
> backup was applied. Is it possible to undo the restore from the log
backup?
> Thanks,
> Bing