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 level. Show all posts
Showing posts with label level. 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;
>
>
Monday, March 12, 2012
Need advice on ETL architecture...
I am about to design (I think it could be considered as) ETL system and here
are my thoughts on how it should work at a very high level.
My intention in this post is to find out if there is a better way to design
this.
Data is originally entered in an as400 system.
On nightly basis, openquery from sql server is used to get all the tables
into "extract_database" as is from as400.
"User_database" takes data on nightly basis from "extract_database"
and converts data into user friendly tables. These tables could be
used by front end programmers to write tsql to drive the front end.
If we have a table called "Sales" then on nightly basis "Sales" table would
get refreshed from as400 and if there is a change in particluar sales order
then I want "user_database" to have the latest change in Sales table.
Some how I also want to document the change in Sales history. In other words
I don't want to lose any data change from day to day.
I also would like to have "history_database" which would keep track of
record changes or deletion.
In summary, "extract_database" has the copy of what exactly got imported,
"user_database" has the converted data so that front end application could
tap into it, and "history_database" is used for reporting.
For daily data refresh, I would like to daily keep track of data imported
for each table.
Are there any white papers, articles, web sites, books that address this
nightly database refresh design and best practices'
Please excuse me in advance if I missed some thing.
TIA..Read about the audit tools that you can buy to do this.|||What you are describing is a transactional data warehouse. The ETL (Extract
Transform Load) programming is just the tip of the iceburg.
"sqlster" <nospam@.nospam.com> wrote in message
news:AB2E77C4-8B79-4CC4-8B0D-2FF079239E1C@.microsoft.com...
>I am about to design (I think it could be considered as) ETL system and
>here
> are my thoughts on how it should work at a very high level.
> My intention in this post is to find out if there is a better way to
> design
> this.
> Data is originally entered in an as400 system.
> On nightly basis, openquery from sql server is used to get all the tables
> into "extract_database" as is from as400.
> "User_database" takes data on nightly basis from "extract_database"
> and converts data into user friendly tables. These tables could be
> used by front end programmers to write tsql to drive the front end.
> If we have a table called "Sales" then on nightly basis "Sales" table
> would
> get refreshed from as400 and if there is a change in particluar sales
> order
> then I want "user_database" to have the latest change in Sales table.
> Some how I also want to document the change in Sales history. In other
> words
> I don't want to lose any data change from day to day.
> I also would like to have "history_database" which would keep track of
> record changes or deletion.
> In summary, "extract_database" has the copy of what exactly got imported,
> "user_database" has the converted data so that front end application could
> tap into it, and "history_database" is used for reporting.
> For daily data refresh, I would like to daily keep track of data imported
> for each table.
> Are there any white papers, articles, web sites, books that address this
> nightly database refresh design and best practices'
> Please excuse me in advance if I missed some thing.
> TIA..
>
are my thoughts on how it should work at a very high level.
My intention in this post is to find out if there is a better way to design
this.
Data is originally entered in an as400 system.
On nightly basis, openquery from sql server is used to get all the tables
into "extract_database" as is from as400.
"User_database" takes data on nightly basis from "extract_database"
and converts data into user friendly tables. These tables could be
used by front end programmers to write tsql to drive the front end.
If we have a table called "Sales" then on nightly basis "Sales" table would
get refreshed from as400 and if there is a change in particluar sales order
then I want "user_database" to have the latest change in Sales table.
Some how I also want to document the change in Sales history. In other words
I don't want to lose any data change from day to day.
I also would like to have "history_database" which would keep track of
record changes or deletion.
In summary, "extract_database" has the copy of what exactly got imported,
"user_database" has the converted data so that front end application could
tap into it, and "history_database" is used for reporting.
For daily data refresh, I would like to daily keep track of data imported
for each table.
Are there any white papers, articles, web sites, books that address this
nightly database refresh design and best practices'
Please excuse me in advance if I missed some thing.
TIA..Read about the audit tools that you can buy to do this.|||What you are describing is a transactional data warehouse. The ETL (Extract
Transform Load) programming is just the tip of the iceburg.
"sqlster" <nospam@.nospam.com> wrote in message
news:AB2E77C4-8B79-4CC4-8B0D-2FF079239E1C@.microsoft.com...
>I am about to design (I think it could be considered as) ETL system and
>here
> are my thoughts on how it should work at a very high level.
> My intention in this post is to find out if there is a better way to
> design
> this.
> Data is originally entered in an as400 system.
> On nightly basis, openquery from sql server is used to get all the tables
> into "extract_database" as is from as400.
> "User_database" takes data on nightly basis from "extract_database"
> and converts data into user friendly tables. These tables could be
> used by front end programmers to write tsql to drive the front end.
> If we have a table called "Sales" then on nightly basis "Sales" table
> would
> get refreshed from as400 and if there is a change in particluar sales
> order
> then I want "user_database" to have the latest change in Sales table.
> Some how I also want to document the change in Sales history. In other
> words
> I don't want to lose any data change from day to day.
> I also would like to have "history_database" which would keep track of
> record changes or deletion.
> In summary, "extract_database" has the copy of what exactly got imported,
> "user_database" has the converted data so that front end application could
> tap into it, and "history_database" is used for reporting.
> For daily data refresh, I would like to daily keep track of data imported
> for each table.
> Are there any white papers, articles, web sites, books that address this
> nightly database refresh design and best practices'
> Please excuse me in advance if I missed some thing.
> TIA..
>
Subscribe to:
Posts (Atom)