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...
> 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 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
>news:99d601c49749$8f959c10$a601280a@.phx.gbl...
>> 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.
>>
>>.
>
>.
>