Help with restoring dropped table

Help! I just accidentally dropped a table in the database. How can I restore it?
Provided you have a full backup and or a series of backups (starting with
afull backup, maybe a differential and a series of tranlogs) of your
database prior to the deletion you can do this:
1) Perform a transaction log backup.
2) Restore the database starting with the full backup and then using the
STOPAT option when you restore from the tranlog backup taking in step one.
You would STOPAT the point in time just prior to when you deleted the table.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:8E9F47E4-57D7-4498-9E97-9BEEB1AFC4AB@.microsoft.com...
> Help! I just accidentally dropped a table in the database. How can I
restore it?
|||Waldemar,
In addition to Greg's suggestion, check out "log explorer" in
www.lumigent.com
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:8E9F47E4-57D7-4498-9E97-9BEEB1AFC4AB@.microsoft.com...
> Help! I just accidentally dropped a table in the database. How can I
restore it?
|||What can I do if I do not have a full backup, only a copy of yesterday's database?
|||Hi Waldemar,
What is recovery model set for your database. STOPAT (POINT_IN_RECOVERY)
will only work if your recover model is FULL.
If it is full then you can go ahead with the option specified by "Gregory"
to do a point in time recovery.
Steps:-
1. Take a transaction log backup.
2. Restore the yesterdays full database backup to a new database with
"norecovery" option
3. Restore the trsnaction log backup to the new database with "RECOVERY" and
STOPAT option.
If your recovery model is SIMPLE or BULK_Logged then , you can get the data
only till last day
1. Restore the yesterdays fulll database backup to a new database
2. Pick the data available in the table and load it to actual database
3. This case u loose the data after the last backup till data loss.
Thanks
Hari
MCDBA
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:edev0d3PEHA.624@.TK2MSFTNGP11.phx.gbl...
> Provided you have a full backup and or a series of backups (starting with
> afull backup, maybe a differential and a series of tranlogs) of your
> database prior to the deletion you can do this:
> 1) Perform a transaction log backup.
> 2) Restore the database starting with the full backup and then using the
> STOPAT option when you restore from the tranlog backup taking in step one.
> You would STOPAT the point in time just prior to when you deleted the
table.
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
> news:8E9F47E4-57D7-4498-9E97-9BEEB1AFC4AB@.microsoft.com...
> restore it?
>
|||You can restore that backup into a new database name and copy the table from there into your production
database. Watch out for dependencies, though!
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:795D7014-4206-426C-927B-C62E1C1A43F4@.microsoft.com...
> What can I do if I do not have a full backup, only a copy of yesterday's database?
|||If you only have a copy of the data files, you might try to sp_attach_db
using a different name. If the attach works, then you can simple insert
select to get the data moved.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:795D7014-4206-426C-927B-C62E1C1A43F4@.microsoft.com...
> What can I do if I do not have a full backup, only a copy of yesterday's
database?

Help with restoring dropped table

Help! I just accidentally dropped a table in the database. How can I restore it?Provided you have a full backup and or a series of backups (starting with
afull backup, maybe a differential and a series of tranlogs) of your
database prior to the deletion you can do this:
1) Perform a transaction log backup.
2) Restore the database starting with the full backup and then using the
STOPAT option when you restore from the tranlog backup taking in step one.
You would STOPAT the point in time just prior to when you deleted the table.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:8E9F47E4-57D7-4498-9E97-9BEEB1AFC4AB@.microsoft.com...
> Help! I just accidentally dropped a table in the database. How can I
restore it?|||Waldemar,
In addition to Greg's suggestion, check out "log explorer" in
www.lumigent.com
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:8E9F47E4-57D7-4498-9E97-9BEEB1AFC4AB@.microsoft.com...
> Help! I just accidentally dropped a table in the database. How can I
restore it?|||What can I do if I do not have a full backup, only a copy of yesterday's database?|||Hi Waldemar,
What is recovery model set for your database. STOPAT (POINT_IN_RECOVERY)
will only work if your recover model is FULL.
If it is full then you can go ahead with the option specified by "Gregory"
to do a point in time recovery.
Steps:-
1. Take a transaction log backup.
2. Restore the yesterdays full database backup to a new database with
"norecovery" option
3. Restore the trsnaction log backup to the new database with "RECOVERY" and
STOPAT option.
If your recovery model is SIMPLE or BULK_Logged then , you can get the data
only till last day
1. Restore the yesterdays fulll database backup to a new database
2. Pick the data available in the table and load it to actual database
3. This case u loose the data after the last backup till data loss.
Thanks
Hari
MCDBA
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:edev0d3PEHA.624@.TK2MSFTNGP11.phx.gbl...
> Provided you have a full backup and or a series of backups (starting with
> afull backup, maybe a differential and a series of tranlogs) of your
> database prior to the deletion you can do this:
> 1) Perform a transaction log backup.
> 2) Restore the database starting with the full backup and then using the
> STOPAT option when you restore from the tranlog backup taking in step one.
> You would STOPAT the point in time just prior to when you deleted the
table.
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
> news:8E9F47E4-57D7-4498-9E97-9BEEB1AFC4AB@.microsoft.com...
> > Help! I just accidentally dropped a table in the database. How can I
> restore it?
>|||You can restore that backup into a new database name and copy the table from there into your production
database. Watch out for dependencies, though!
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:795D7014-4206-426C-927B-C62E1C1A43F4@.microsoft.com...
> What can I do if I do not have a full backup, only a copy of yesterday's database?|||If you only have a copy of the data files, you might try to sp_attach_db
using a different name. If the attach works, then you can simple insert
select to get the data moved.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:795D7014-4206-426C-927B-C62E1C1A43F4@.microsoft.com...
> What can I do if I do not have a full backup, only a copy of yesterday's
database?

Help with restoring dropped table

Help! I just accidentally dropped a table in the database. How can I restore
it?Provided you have a full backup and or a series of backups (starting with
afull backup, maybe a differential and a series of tranlogs) of your
database prior to the deletion you can do this:
1) Perform a transaction log backup.
2) Restore the database starting with the full backup and then using the
STOPAT option when you restore from the tranlog backup taking in step one.
You would STOPAT the point in time just prior to when you deleted the table.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:8E9F47E4-57D7-4498-9E97-9BEEB1AFC4AB@.microsoft.com...
> Help! I just accidentally dropped a table in the database. How can I
restore it?|||Waldemar,
In addition to Greg's suggestion, check out "log explorer" in
www.lumigent.com
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:8E9F47E4-57D7-4498-9E97-9BEEB1AFC4AB@.microsoft.com...
> Help! I just accidentally dropped a table in the database. How can I
restore it?|||What can I do if I do not have a full backup, only a copy of yesterday's dat
abase?|||Hi Waldemar,
What is recovery model set for your database. STOPAT (POINT_IN_RECOVERY)
will only work if your recover model is FULL.
If it is full then you can go ahead with the option specified by "Gregory"
to do a point in time recovery.
Steps:-
1. Take a transaction log backup.
2. Restore the yesterdays full database backup to a new database with
"norecovery" option
3. Restore the trsnaction log backup to the new database with "RECOVERY" and
STOPAT option.
If your recovery model is SIMPLE or BULK_Logged then , you can get the data
only till last day
1. Restore the yesterdays fulll database backup to a new database
2. Pick the data available in the table and load it to actual database
3. This case u loose the data after the last backup till data loss.
Thanks
Hari
MCDBA
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:edev0d3PEHA.624@.TK2MSFTNGP11.phx.gbl...
> Provided you have a full backup and or a series of backups (starting with
> afull backup, maybe a differential and a series of tranlogs) of your
> database prior to the deletion you can do this:
> 1) Perform a transaction log backup.
> 2) Restore the database starting with the full backup and then using the
> STOPAT option when you restore from the tranlog backup taking in step one.
> You would STOPAT the point in time just prior to when you deleted the
table.
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
> news:8E9F47E4-57D7-4498-9E97-9BEEB1AFC4AB@.microsoft.com...
> restore it?
>|||You can restore that backup into a new database name and copy the table from
there into your production
database. Watch out for dependencies, though!
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:795D7014-4206-426C-927B-C62E1C1A43F4@.microsoft.com...
> What can I do if I do not have a full backup, only a copy of yesterday's database?
|||If you only have a copy of the data files, you might try to sp_attach_db
using a different name. If the attach works, then you can simple insert
select to get the data moved.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Waldemar" <anonymous@.discussions.microsoft.com> wrote in message
news:795D7014-4206-426C-927B-C62E1C1A43F4@.microsoft.com...
> What can I do if I do not have a full backup, only a copy of yesterday's
database?sql

help with restore filegroup

hi !
I need help with restore a filegroup. Below are steps
which I made, what is wrong '
Steps:
- create a new filegroup "SE" and assign to it a few
tables. - OK
- make a backup new created filegroup "SE" - OK
- make a backup log file - OK
- drop one table "A1" from filegroup "SE" - OK
- make a backup log file (necessary to restore)- OK
- make a restore filegroup "SE" and log files - OK
my question is why after restore filegroup I haven't
droppped table "A1" '
I readed a documentation on microsoft - I think that all
is done ok.
Maybe I missing some details or something else '
thank for any answer, and sorry for my english The table A! should not be there after the file group restore. Are you
saying that it is there? If so, can you please post the CREATE DATABASE,
CREATE TABLE, ALTER DATABASE, BACKUP and RESTORE statements with which we
can reproduce this? It is always easier to talk about these things when
having statements available instead of guessing what you are doing (and
possibly how you are clicking etc in Enterprise Manager).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"rafal" <anonymous@.discussions.microsoft.com> wrote in message
news:198701c410c8$0e2a66e0$3501280a@.phx.gbl...
> hi !
> I need help with restore a filegroup. Below are steps
> which I made, what is wrong '
> Steps:
> - create a new filegroup "SE" and assign to it a few
> tables. - OK
> - make a backup new created filegroup "SE" - OK
> - make a backup log file - OK
> - drop one table "A1" from filegroup "SE" - OK
> - make a backup log file (necessary to restore)- OK
> - make a restore filegroup "SE" and log files - OK
> my question is why after restore filegroup I haven't
> droppped table "A1" '
> I readed a documentation on microsoft - I think that all
> is done ok.
> Maybe I missing some details or something else '
> thank for any answer, and sorry for my english |||hi again
thanks for answer Tibor,
Where is my problem ? - I have a database where are some
tables. A few from them grow up much more than rest. My
problem is to backup often tables where is bigger increase
of rows. Then I created a group and assigned to it these
tables with big increase of rows.
What I want to do ? - I want to backup only one group
which I created.
Here is the example code that I execute in QueryAnalyzer.
All of them are executed without errors but result is not
satisfactory
Steps:
1. create database:
CREATE DATABASE TEST
ON PRIMARY
( NAME = TEST_dat,
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\testDat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 15% ),
FILEGROUP TestGroup1
( NAME = TESTGROUP_dat,
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\TestGroupDat.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'TEST_log',
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\TestLog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
2. use database
use test
3. create tables in database
first
create table A1 (
id int,
name char(50),
age int
)
ON 'TestGroup1'
second
create table A2(
id int,
field char(50)
)
ON 'PRIMARY'
4. insert example data
insert a2 values (1,'third')
insert a1 values (1,'Czesiek',12)
insert a1 values (2,'Wieseik',23)
insert a1 values (3,'Misiek',42)
5. backup interesting group
backup database test filegroup = 'testgroup1'
to disk = 'c:\testdb\gr1.bak'
6.backup log
backup log test
to disk ='c:\testdb\testlog.log'
7. delete data on table a1 (simulate losing data)
delete from a1 where age > 12
8. backup log (needed to restore filegroup)
backup log test
to disk = 'c:\testdb\beforRestore.log'
9. restore group
restore database test
file = 'testgroup_dat',
filegroup ='testgroup1'
from disk = 'c:\testdb\gr1.bak'
10. restore log
restore log test
from disk = 'c:\testdb\testlog.log'
with norecovery
11.restore last log
restore log test
from disk = 'c:\testdb\beforrestore.log'
with recovery
Is it done in a good order or not ?
Why after restore group and all log files I haven't
deleted in step 7 data ?
any suggestion ?
where is bug ?
thanks, rafal|||I'm not 100% certain on what you want to achieve, but I guess that you want
to undo the deletions. However,
you cannot use filegroup backup for this. When you do a restore of a partial
backup (file or filegroup), you
have to restore all log backups taken after that point in time, including th
at last one. No point in time, as
SQL server wouldn't know how to synchronize the work done against the filegr
oup (which you do not restore in
full) to the other part of the database. This is all documented in Books Onl
ine. If you want to communicate
this further, please use my below script. I have revised it a bit, so you do
n't have to create directories,
and also so you can execute it all in one go.
DROP DATABASE TEST
GO
CREATE DATABASE TEST
ON PRIMARY
( NAME = TEST_dat,
FILENAME = 'c:\testDat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 15% ),
FILEGROUP TestGroup1
( NAME = TESTGROUP_dat,
FILENAME = 'c:\TestGroupDat.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'TEST_log',
FILENAME = 'c:\TestLog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO
--2. use database
USE test
--3. create tables in databasefirst
create table A1 ( id int, name char(50), age int ) ON 'TestGroup1'
--second
create table A2( id int, field char(50) ) ON 'PRIMARY'
--4. insert example data
insert a2 values (1,'third')
insert a1 values (1,'Czesiek',12)
insert a1 values (2,'Wieseik',23)
insert a1 values (3,'Misiek',42)
--5. backup interesting group
backup database test filegroup = 'testgroup1' to disk = 'c:\gr1.bak' WITH IN
IT
--backup database test to disk = 'c:\gr1.bak' WITH INIT
--6.backup log
backup log test to disk ='c:\testlog.log' WITH INIT
--7. delete data on table a1 (simulate losing data)
BEGIN TRAN x WITH MARK 'x'
delete from a1 where age > 12
COMMIT TRAN
--8. backup log (needed to restore filegroup)
backup log test to disk = 'c:\beforRestore.log' WITH INIT
--8.5 use master
USE master
--9. restore group
restore database test filegroup ='testgroup1' from disk = 'c:\gr1.bak'
--restore database test file = 'testgroup_dat', filegroup ='testgroup1' fro
m disk = 'c:\gr1.bak'
--restore database test from disk = 'c:\gr1.bak' with norecovery
--10. restore log
restore log test from disk = 'c:\testlog.log' with norecovery
--11.restore last log
restore log test from disk = 'c:\beforrestore.log' with recovery
, STOPBEFOREMARK = 'x'
GO
--Is the data still there?
SELECT * FROM test..a1
SELECT * FROM test..a2
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"rafal" <anonymous@.discussions.microsoft.com> wrote in message news:1c4501c411a5$12e74940$3
a01280a@.phx.gbl...
> hi again
> thanks for answer Tibor,
> Where is my problem ? - I have a database where are some
> tables. A few from them grow up much more than rest. My
> problem is to backup often tables where is bigger increase
> of rows. Then I created a group and assigned to it these
> tables with big increase of rows.
> What I want to do ? - I want to backup only one group
> which I created.
> Here is the example code that I execute in QueryAnalyzer.
> All of them are executed without errors but result is not
> satisfactory
> Steps:
> 1. create database:
> CREATE DATABASE TEST
> ON PRIMARY
> ( NAME = TEST_dat,
> FILENAME = 'c:\program files\microsoft sql
> server\mssql\data\testDat.mdf',
> SIZE = 10,
> MAXSIZE = 50,
> FILEGROWTH = 15% ),
> FILEGROUP TestGroup1
> ( NAME = TESTGROUP_dat,
> FILENAME = 'c:\program files\microsoft sql
> server\mssql\data\TestGroupDat.ndf',
> SIZE = 10,
> MAXSIZE = 50,
> FILEGROWTH = 5 )
> LOG ON
> ( NAME = 'TEST_log',
> FILENAME = 'c:\program files\microsoft sql
> server\mssql\data\TestLog.ldf',
> SIZE = 5MB,
> MAXSIZE = 25MB,
> FILEGROWTH = 5MB )
> 2. use database
> use test
> 3. create tables in database
> first
> create table A1 (
> id int,
> name char(50),
> age int
> )
> ON 'TestGroup1'
> second
> create table A2(
> id int,
> field char(50)
> )
> ON 'PRIMARY'
> 4. insert example data
> insert a2 values (1,'third')
> insert a1 values (1,'Czesiek',12)
> insert a1 values (2,'Wieseik',23)
> insert a1 values (3,'Misiek',42)
> 5. backup interesting group
> backup database test filegroup = 'testgroup1'
> to disk = 'c:\testdb\gr1.bak'
> 6.backup log
> backup log test
> to disk ='c:\testdb\testlog.log'
> 7. delete data on table a1 (simulate losing data)
> delete from a1 where age > 12
> 8. backup log (needed to restore filegroup)
> backup log test
> to disk = 'c:\testdb\beforRestore.log'
> 9. restore group
> restore database test
> file = 'testgroup_dat',
> filegroup ='testgroup1'
> from disk = 'c:\testdb\gr1.bak'
> 10. restore log
> restore log test
> from disk = 'c:\testdb\testlog.log'
> with norecovery
> 11.restore last log
> restore log test
> from disk = 'c:\testdb\beforrestore.log'
> with recovery
>
> Is it done in a good order or not ?
> Why after restore group and all log files I haven't
> deleted in step 7 data ?
> any suggestion ?
> where is bug ?
> thanks, rafal

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,
George
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...
> 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'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
>
>
|||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...[vbcol=seagreen]
> 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
>
|||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]

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'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
>
>|||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...
> > 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
> >
> >
>|||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...
> 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'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
> >
> >
> >

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]