I am looking for backup software to backup my SQL 2000 Server database. It
should be able to perform object level recobery.
Are there any recommendations?
Thanks in advance;SQL 2000 provides it's own backup functionality that will do
transaction level recovery.
Then backup software just needs to grab the .bak and .trn files.|||"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:38F89FA5-9441-4BC9-B9B9-43AF42B24135@.microsoft.com...
> I am looking for backup software to backup my SQL 2000 Server database. It
> should be able to perform object level recobery.
> Are there any recommendations?
>
Start by looking at the SQL Server native backup jobs.
SQL Litespeed by Imceda is worth a look too.
> Thanks in advance;
>|||This is a multi-part message in MIME format.
--030603030209080206050108
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Can't go past the good old T-SQL BACKUP DATABASE/BACKUP LOG statements IMHO.
--
*mike hodgson*
http://sqlnerd.blogspot.com
Mike Torry wrote:
>I am looking for backup software to backup my SQL 2000 Server database. It
>should be able to perform object level recobery.
>Are there any recommendations?
>Thanks in advance;
>
>
--030603030209080206050108
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Can't go past the good old T-SQL BACKUP DATABASE/BACKUP LOG
statements IMHO.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Mike Torry wrote:
<blockquote cite="mid38F89FA5-9441-4BC9-B9B9-43AF42B24135@.microsoft.com"
type="cite">
<pre wrap="">I am looking for backup software to backup my SQL 2000 Server database. It
should be able to perform object level recobery.
Are there any recommendations?
Thanks in advance;
</pre>
</blockquote>
</body>
</html>
--030603030209080206050108--
Showing posts with label object. Show all posts
Showing posts with label object. Show all posts
Monday, March 26, 2012
Need good backup software
I am looking for backup software to backup my SQL 2000 Server database. It
should be able to perform object level recobery.
Are there any recommendations?
Thanks in advance;SQL 2000 provides it's own backup functionality that will do
transaction level recovery.
Then backup software just needs to grab the .bak and .trn files.|||"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:38F89FA5-9441-4BC9-B9B9-43AF42B24135@.microsoft.com...
> I am looking for backup software to backup my SQL 2000 Server database. It
> should be able to perform object level recobery.
> Are there any recommendations?
>
Start by looking at the SQL Server native backup jobs.
SQL Litespeed by Imceda is worth a look too.
> Thanks in advance;
>|||Can't go past the good old T-SQL BACKUP DATABASE/BACKUP LOG statements IMHO.
*mike hodgson*
http://sqlnerd.blogspot.com
Mike Torry wrote:
>I am looking for backup software to backup my SQL 2000 Server database. It
>should be able to perform object level recobery.
>Are there any recommendations?
>Thanks in advance;
>
>
should be able to perform object level recobery.
Are there any recommendations?
Thanks in advance;SQL 2000 provides it's own backup functionality that will do
transaction level recovery.
Then backup software just needs to grab the .bak and .trn files.|||"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:38F89FA5-9441-4BC9-B9B9-43AF42B24135@.microsoft.com...
> I am looking for backup software to backup my SQL 2000 Server database. It
> should be able to perform object level recobery.
> Are there any recommendations?
>
Start by looking at the SQL Server native backup jobs.
SQL Litespeed by Imceda is worth a look too.
> Thanks in advance;
>|||Can't go past the good old T-SQL BACKUP DATABASE/BACKUP LOG statements IMHO.
*mike hodgson*
http://sqlnerd.blogspot.com
Mike Torry wrote:
>I am looking for backup software to backup my SQL 2000 Server database. It
>should be able to perform object level recobery.
>Are there any recommendations?
>Thanks in advance;
>
>
Wednesday, March 21, 2012
Need child TABLE object to ref diff DATASET than parent LIST object.
Dang, I wish I had figured this out without having to ask.
Looked and looked for a similar thread - but no real "keyword" for
this issue.
Here's the situation; imagine you have customers and one database
table has demographic information while another database table has a
list of customer orders. Now you want a report that shows all that on
a document map-driven report.
Here's the page layout:
LIST OBJECT // DATASET(dsDemographics) GROUPBY(customer)
DOCMAP(customer)
>> TABLE OBJECT DATASET(dsDemographics) GROUPBY()
>> TABLE OBJECT DATASET(dsOrders) GROUPBY(orderdate)
>> TABLE OBJECT DATASET(dsTickets) GROUPBY(createdate)
Here's the problem: the second table containing orders will not
reference the dsOrders DATASET unless through aggregations - which is
obviously not what I am wanting to do. I want to list all the orders
for the current customer. Same problem with the third table - and
others.
Now, I see the problem is very clear. The orders DATASET does not know
how to filter itself on the current customer. That much I understand.
How do I do it?
Thanks in advance, JerrySounds like your needing to join the datasets. Easiest way would be to join
the data prior to pulling it into RS because, as you noted, RS can only join
data from one dataset to another using an aggregate. If one of your
datasets is SQL, you might use a linked server to pre-join your data.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Jerry Nixon" <jerrynixon@.gmail.com> wrote in message
news:36f558cf.0410221151.4074f9f8@.posting.google.com...
> Dang, I wish I had figured this out without having to ask.
> Looked and looked for a similar thread - but no real "keyword" for
> this issue.
> Here's the situation; imagine you have customers and one database
> table has demographic information while another database table has a
> list of customer orders. Now you want a report that shows all that on
> a document map-driven report.
> Here's the page layout:
> LIST OBJECT // DATASET(dsDemographics) GROUPBY(customer)
> DOCMAP(customer)
>> TABLE OBJECT DATASET(dsDemographics) GROUPBY()
>> TABLE OBJECT DATASET(dsOrders) GROUPBY(orderdate)
>> TABLE OBJECT DATASET(dsTickets) GROUPBY(createdate)
> Here's the problem: the second table containing orders will not
> reference the dsOrders DATASET unless through aggregations - which is
> obviously not what I am wanting to do. I want to list all the orders
> for the current customer. Same problem with the third table - and
> others.
> Now, I see the problem is very clear. The orders DATASET does not know
> how to filter itself on the current customer. That much I understand.
> How do I do it?
> Thanks in advance, Jerry
Looked and looked for a similar thread - but no real "keyword" for
this issue.
Here's the situation; imagine you have customers and one database
table has demographic information while another database table has a
list of customer orders. Now you want a report that shows all that on
a document map-driven report.
Here's the page layout:
LIST OBJECT // DATASET(dsDemographics) GROUPBY(customer)
DOCMAP(customer)
>> TABLE OBJECT DATASET(dsDemographics) GROUPBY()
>> TABLE OBJECT DATASET(dsOrders) GROUPBY(orderdate)
>> TABLE OBJECT DATASET(dsTickets) GROUPBY(createdate)
Here's the problem: the second table containing orders will not
reference the dsOrders DATASET unless through aggregations - which is
obviously not what I am wanting to do. I want to list all the orders
for the current customer. Same problem with the third table - and
others.
Now, I see the problem is very clear. The orders DATASET does not know
how to filter itself on the current customer. That much I understand.
How do I do it?
Thanks in advance, JerrySounds like your needing to join the datasets. Easiest way would be to join
the data prior to pulling it into RS because, as you noted, RS can only join
data from one dataset to another using an aggregate. If one of your
datasets is SQL, you might use a linked server to pre-join your data.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Jerry Nixon" <jerrynixon@.gmail.com> wrote in message
news:36f558cf.0410221151.4074f9f8@.posting.google.com...
> Dang, I wish I had figured this out without having to ask.
> Looked and looked for a similar thread - but no real "keyword" for
> this issue.
> Here's the situation; imagine you have customers and one database
> table has demographic information while another database table has a
> list of customer orders. Now you want a report that shows all that on
> a document map-driven report.
> Here's the page layout:
> LIST OBJECT // DATASET(dsDemographics) GROUPBY(customer)
> DOCMAP(customer)
>> TABLE OBJECT DATASET(dsDemographics) GROUPBY()
>> TABLE OBJECT DATASET(dsOrders) GROUPBY(orderdate)
>> TABLE OBJECT DATASET(dsTickets) GROUPBY(createdate)
> Here's the problem: the second table containing orders will not
> reference the dsOrders DATASET unless through aggregations - which is
> obviously not what I am wanting to do. I want to list all the orders
> for the current customer. Same problem with the third table - and
> others.
> Now, I see the problem is very clear. The orders DATASET does not know
> how to filter itself on the current customer. That much I understand.
> How do I do it?
> Thanks in advance, Jerry
Subscribe to:
Posts (Atom)