How to rollback the database

I am NOT talking about one transaction. I need to go back
a day or more. Either 7 or 2000. Not a stand by server
either.
Is it possible? Please answer.
Aziz wrote:
> I am NOT talking about one transaction. I need to go back
> a day or more. Either 7 or 2000. Not a stand by server
> either.
> Is it possible? Please answer.
You can restore a backup and then restore the transaction log to a point
in time. Is that what you are looking for? You'll need a database
backup, plus and transaction logs for this to happen.
David G.
|||Possible, if you have a backups of the database, that were taken at the
point, to which you want to rollback to.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Aziz" <goaziz@.yahoo.com> wrote in message
news:92fc01c496b9$080bbe40$a501280a@.phx.gbl...
I am NOT talking about one transaction. I need to go back
a day or more. Either 7 or 2000. Not a stand by server
either.
Is it possible? Please answer.
|||No. I can not use backupp to restore. Because it is too
big. It takes more than 6 hours to restore.

>--Original Message--
>Possible, if you have a backups of the database, that
were taken at the
>point, to which you want to rollback to.
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"Aziz" <goaziz@.yahoo.com> wrote in message
>news:92fc01c496b9$080bbe40$a501280a@.phx.gbl...
>I am NOT talking about one transaction. I need to go back
>a day or more. Either 7 or 2000. Not a stand by server
>either.
>Is it possible? Please answer.
>
>.
>
|||There is not functionality in SQL Server where you can tell the product to go back a certain amount
of time. Restore is your option.
However, you can look at the log reading tools available, see my links page for where to find some
of them.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote in message
news:99d601c49749$8f959c10$a601280a@.phx.gbl...[vbcol=seagreen]
> No. I can not use backupp to restore. Because it is too
> big. It takes more than 6 hours to restore.
>
> were taken at the
|||There is an option built into Lumigent's Log Explorer
to "back out" transactions.
This may accomplish what you need, assuming you haven't
truncated your log.
Matthew Bando
Matthew.Bando@.remove CSCTGI.com

>--Original Message--
>There is not functionality in SQL Server where you can
tell the product to go back a certain amount
>of time. Restore is your option.
>However, you can look at the log reading tools
available, see my links page for where to find some
>of them.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote
in message[vbcol=seagreen]
>news:99d601c49749$8f959c10$a601280a@.phx.gbl...
back
>
>.
>