Restore two individual tables from massive DB into new DB

I need to pull two individual tables out of a very large DB into a new
DB for testing. I know this is probably easy for a more experienced
DBA, but I'm still learning.
Thanks.Probably best to transfer them from one to the other using DTS (SQL 2000) or
SSIS (SQL 2005) package during off hours.
How many rows in the tables that you need to move?
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Matt" <matthewsatkins@.gmail.com> wrote in message
news:c19a7ff0-c2f2-452a-9841-853cd393c917@.l1g2000hsa.googlegroups.com...
>I need to pull two individual tables out of a very large DB into a new
> DB for testing. I know this is probably easy for a more experienced
> DBA, but I'm still learning.
> Thanks.

Restore transactions based on date range?

Hi there -- I'm a developer who mostly uses SQL Server from that
perspective, not a DBA, and I had a client ask me a question recently that I
couldn't answer.
My client has a database that is updated constantly. A few weeks ago, he
accidentially deleted about two weeks worth of data from the database.
Since then the db's users have continued to update new data. So basically
the database is missing about two weeks worth of data from a couple of
months ago.
Is there a way to restore just those two weeks worth of data from the
transaction logs? From everything that I know and everything I've found,
you restore a database to a point in time, instead of picking out a date
range from a backup. But as I said, I'm not a DBA. So any advice would be
appreciated. Thanks!
Thanks for your help! I will pass this info along.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23qmgAZKRHHA.4252@.TK2MSFTNGP05.phx.gbl...
> If your customer has transaction log backups covering this period, you
> might be able to do this.
> Either restore (db and then log backups) up to just before that deletion,
> to a new database. Then transfer the desired data over to the production
> database (take relationships, constraints, triggers etc into
> considerations).
> Or, use some log reader tool and see if it can "mine" out counter
> statements for the delete process from your log backup. I've listed some
> such tools at http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mike Ripplinger" <miker@.entrerock.com> wrote in message
> news:egaC1EKRHHA.3316@.TK2MSFTNGP02.phx.gbl...
>

Restore transactions based on date range?

Hi there -- I'm a developer who mostly uses SQL Server from that
perspective, not a DBA, and I had a client ask me a question recently that I
couldn't answer.
My client has a database that is updated constantly. A few weeks ago, he
accidentially deleted about two weeks worth of data from the database.
Since then the db's users have continued to update new data. So basically
the database is missing about two weeks worth of data from a couple of
months ago.
Is there a way to restore just those two weeks worth of data from the
transaction logs? From everything that I know and everything I've found,
you restore a database to a point in time, instead of picking out a date
range from a backup. But as I said, I'm not a DBA. So any advice would be
appreciated. Thanks!If your customer has transaction log backups covering this period, you might
be able to do this.
Either restore (db and then log backups) up to just before that deletion, to
a new database. Then
transfer the desired data over to the production database (take relationship
s, constraints, triggers
etc into considerations).
Or, use some log reader tool and see if it can "mine" out counter statements
for the delete process
from your log backup. I've listed some such tools at http://www.karaszi.com/SQLSer
ver/links.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Ripplinger" <miker@.entrerock.com> wrote in message
news:egaC1EKRHHA.3316@.TK2MSFTNGP02.phx.gbl...
> Hi there -- I'm a developer who mostly uses SQL Server from that perspecti
ve, not a DBA, and I had
> a client ask me a question recently that I couldn't answer.
> My client has a database that is updated constantly. A few weeks ago, he
accidentially deleted
> about two weeks worth of data from the database. Since then the db's users
have continued to
> update new data. So basically the database is missing about two weeks wor
th of data from a couple
> of months ago.
> Is there a way to restore just those two weeks worth of data from the tran
saction logs? From
> everything that I know and everything I've found, you restore a database t
o a point in time,
> instead of picking out a date range from a backup. But as I said, I'm not
a DBA. So any advice
> would be appreciated. Thanks!
>|||Thanks for your help! I will pass this info along.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23qmgAZKRHHA.4252@.TK2MSFTNGP05.phx.gbl...
> If your customer has transaction log backups covering this period, you
> might be able to do this.
> Either restore (db and then log backups) up to just before that deletion,
> to a new database. Then transfer the desired data over to the production
> database (take relationships, constraints, triggers etc into
> considerations).
> Or, use some log reader tool and see if it can "mine" out counter
> statements for the delete process from your log backup. I've listed some
> such tools at http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mike Ripplinger" <miker@.entrerock.com> wrote in message
> news:egaC1EKRHHA.3316@.TK2MSFTNGP02.phx.gbl...
>sql

Restore transactions based on date range?

Hi there -- I'm a developer who mostly uses SQL Server from that
perspective, not a DBA, and I had a client ask me a question recently that I
couldn't answer.
My client has a database that is updated constantly. A few weeks ago, he
accidentially deleted about two weeks worth of data from the database.
Since then the db's users have continued to update new data. So basically
the database is missing about two weeks worth of data from a couple of
months ago.
Is there a way to restore just those two weeks worth of data from the
transaction logs? From everything that I know and everything I've found,
you restore a database to a point in time, instead of picking out a date
range from a backup. But as I said, I'm not a DBA. So any advice would be
appreciated. Thanks!If your customer has transaction log backups covering this period, you might be able to do this.
Either restore (db and then log backups) up to just before that deletion, to a new database. Then
transfer the desired data over to the production database (take relationships, constraints, triggers
etc into considerations).
Or, use some log reader tool and see if it can "mine" out counter statements for the delete process
from your log backup. I've listed some such tools at http://www.karaszi.com/SQLServer/links.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Ripplinger" <miker@.entrerock.com> wrote in message
news:egaC1EKRHHA.3316@.TK2MSFTNGP02.phx.gbl...
> Hi there -- I'm a developer who mostly uses SQL Server from that perspective, not a DBA, and I had
> a client ask me a question recently that I couldn't answer.
> My client has a database that is updated constantly. A few weeks ago, he accidentially deleted
> about two weeks worth of data from the database. Since then the db's users have continued to
> update new data. So basically the database is missing about two weeks worth of data from a couple
> of months ago.
> Is there a way to restore just those two weeks worth of data from the transaction logs? From
> everything that I know and everything I've found, you restore a database to a point in time,
> instead of picking out a date range from a backup. But as I said, I'm not a DBA. So any advice
> would be appreciated. Thanks!
>|||Thanks for your help! I will pass this info along.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23qmgAZKRHHA.4252@.TK2MSFTNGP05.phx.gbl...
> If your customer has transaction log backups covering this period, you
> might be able to do this.
> Either restore (db and then log backups) up to just before that deletion,
> to a new database. Then transfer the desired data over to the production
> database (take relationships, constraints, triggers etc into
> considerations).
> Or, use some log reader tool and see if it can "mine" out counter
> statements for the delete process from your log backup. I've listed some
> such tools at http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mike Ripplinger" <miker@.entrerock.com> wrote in message
> news:egaC1EKRHHA.3316@.TK2MSFTNGP02.phx.gbl...
>> Hi there -- I'm a developer who mostly uses SQL Server from that
>> perspective, not a DBA, and I had a client ask me a question recently
>> that I couldn't answer.
>> My client has a database that is updated constantly. A few weeks ago, he
>> accidentially deleted about two weeks worth of data from the database.
>> Since then the db's users have continued to update new data. So
>> basically the database is missing about two weeks worth of data from a
>> couple of months ago.
>> Is there a way to restore just those two weeks worth of data from the
>> transaction logs? From everything that I know and everything I've found,
>> you restore a database to a point in time, instead of picking out a date
>> range from a backup. But as I said, I'm not a DBA. So any advice would
>> be appreciated. Thanks!
>

Restore Master Database - Permisssions?

I have 2 database servers, 1 @. production and 1 @. DR site.

To restore the master database to DR on a regular basis, I have to rely on either the DBA or SysAdm to perform the restore. It's pretty expensive, as they have to dedicate some time to do so.

I'm exploring the possibility of getting the Data Centre staff to do this instead, as they are stationed at the DR site. Please advise the SQL permisssions required to restore master database.

We are running SQL Server 2000.Its sa only.....and unless you trust the DR people, I would be reluctant to have the sa pasword widely known...