Help with Restore

Folks,
I inherited a database that was not maintained correctly. I have learned
that the previous DBA had not created any SQL backup procedures, so they've
been running for at least 6 months with no safety net. Of course, some data
has been deleted by users and I need to find a way to restore the data as
they are screaming bloody murder.
I do, however, have backups of the data and log files which are from the
regular server backup. Can I create a new database of the correct name on
another server, and then restore those files to that database? Or is it
expecting the server to have the same name as before?
Any and all suggestions are appreciated.
Thanks,
GeorgeGeorge
You definitely can restore a database to onother server.
If you don't have the same files path look at WITH MOVE option in the BOL.
"George Hutto" <yougott@.bekidding.com> wrote in message
news:urzyAmZxEHA.908@.TK2MSFTNGP11.phx.gbl...
> Folks,
> I inherited a database that was not maintained correctly. I have learned
> that the previous DBA had not created any SQL backup procedures, so
they've
> been running for at least 6 months with no safety net. Of course, some
data
> has been deleted by users and I need to find a way to restore the data as
> they are screaming bloody murder.
> I do, however, have backups of the data and log files which are from the
> regular server backup. Can I create a new database of the correct name on
> another server, and then restore those files to that database? Or is it
> expecting the server to have the same name as before?
> Any and all suggestions are appreciated.
> Thanks,
> George
>|||Hi
Just to add, if SQL was shut down at the time of backup, you can use them,
otherwise you don't have anything as the files would have been in use.
Regards
Mike
"George Hutto" wrote:

> Folks,
> I inherited a database that was not maintained correctly. I have learned
> that the previous DBA had not created any SQL backup procedures, so they'v
e
> been running for at least 6 months with no safety net. Of course, some da
ta
> has been deleted by users and I need to find a way to restore the data as
> they are screaming bloody murder.
> I do, however, have backups of the data and log files which are from the
> regular server backup. Can I create a new database of the correct name on
> another server, and then restore those files to that database? Or is it
> expecting the server to have the same name as before?
> Any and all suggestions are appreciated.
> Thanks,
> George
>
>|||Uri,
I don't have .BAK files, what I have are copies of the .DAT and .LOG files
from a particular date. I don't know if we are both talking about the same
sort of scenario.
George
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23UXz6pZxEHA.1524@.TK2MSFTNGP09.phx.gbl...
> George
> You definitely can restore a database to onother server.
> If you don't have the same files path look at WITH MOVE option in the BOL.
>
>
> "George Hutto" <yougott@.bekidding.com> wrote in message
> news:urzyAmZxEHA.908@.TK2MSFTNGP11.phx.gbl...
learned[vbcol=seagreen]
> they've
> data
as[vbcol=seagreen]
on[vbcol=seagreen]
>|||Really Mike? That will make things darned difficult.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:C563452E-54A2-46F6-9E13-7DFE3332B7E1@.microsoft.com...[vbcol=seagreen]
> Hi
> Just to add, if SQL was shut down at the time of backup, you can use them,
> otherwise you don't have anything as the files would have been in use.
> Regards
> Mike
> "George Hutto" wrote:
>
learned[vbcol=seagreen]
they've[vbcol=seagreen]
data[vbcol=seagreen]
as[vbcol=seagreen]
on[vbcol=seagreen]