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 perform. Show all posts
Showing posts with label perform. 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 adviceon SQL Server 2000 Maintenance Plan
Hi:
Is the maintenance plan correct ?
1. Perform DBCC CheckDB on Saturday 8:00PM
2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
every 15 minute, from Monday to Friday and Saturday will start on
8:00AM to 4:00AM
3. Database Full backup will start on 9:00PM from Monday to Friday and
Saturday will backup on 4:00PM.
4. System will remove the transaction log backup which is more than 4
days.
5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
use script to rebuild the index, so that only the fragmented index file
will be rebuild)
Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
minute, from Monday to Saturday.
Will the replication cause the rebuild index fail ? Can transaction log
backup and rebuild index happen at the same time ? I'm afraid the log
file will grow too large during rebuilt index if i don't perform trx
log backup.
Please Advice
Thanks
JCVoonRegarding point 5, do you mean you are running an index defrag? An index
rebuild is on offline operation which will mean the tables will go offline
as the index is being rebuilt. For large tables or if you are a 24x7 shop
this is probably not what you want. An index defrag will cause your tlogs to
ballon considerably, so you might want to shrink them somewhat after the
defrag.
Replication is not impacted by index defrags or rebuilds. Lengthy rebuilds
will cause the tlogs to grow, but you can dump them in the middle of a
rebuild.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1136456692.089320.162270@.g49g2000cwa.googlegroups.com...
> Hi:
> Is the maintenance plan correct ?
> 1. Perform DBCC CheckDB on Saturday 8:00PM
> 2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
> every 15 minute, from Monday to Friday and Saturday will start on
> 8:00AM to 4:00AM
> 3. Database Full backup will start on 9:00PM from Monday to Friday and
> Saturday will backup on 4:00PM.
> 4. System will remove the transaction log backup which is more than 4
> days.
> 5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
> use script to rebuild the index, so that only the fragmented index file
> will be rebuild)
> Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
> minute, from Monday to Saturday.
> Will the replication cause the rebuild index fail ? Can transaction log
> backup and rebuild index happen at the same time ? I'm afraid the log
> file will grow too large during rebuilt index if i don't perform trx
> log backup.
> Please Advice
> Thanks
> JCVoon
>|||Hilary Cotter
Regarding point 5, I'm running an index rebuild, there will be no
operation after 8:00PM
I'm rely on the transaction log backup to minimise the log file grow
during rebuild index, is it possible ?
And for full database backup, the transaction log backup may trigger
during full database backup, is there any side effect ?
The rebuild index and full database backup, which should come first ?
any side effect if the full database backup and rebuild index happen at
the same time ? because i've time overlap on the full database backup
and rebuild index.
Thanks for your help.
Regards
JCvoon
Is the maintenance plan correct ?
1. Perform DBCC CheckDB on Saturday 8:00PM
2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
every 15 minute, from Monday to Friday and Saturday will start on
8:00AM to 4:00AM
3. Database Full backup will start on 9:00PM from Monday to Friday and
Saturday will backup on 4:00PM.
4. System will remove the transaction log backup which is more than 4
days.
5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
use script to rebuild the index, so that only the fragmented index file
will be rebuild)
Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
minute, from Monday to Saturday.
Will the replication cause the rebuild index fail ? Can transaction log
backup and rebuild index happen at the same time ? I'm afraid the log
file will grow too large during rebuilt index if i don't perform trx
log backup.
Please Advice
Thanks
JCVoonRegarding point 5, do you mean you are running an index defrag? An index
rebuild is on offline operation which will mean the tables will go offline
as the index is being rebuilt. For large tables or if you are a 24x7 shop
this is probably not what you want. An index defrag will cause your tlogs to
ballon considerably, so you might want to shrink them somewhat after the
defrag.
Replication is not impacted by index defrags or rebuilds. Lengthy rebuilds
will cause the tlogs to grow, but you can dump them in the middle of a
rebuild.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1136456692.089320.162270@.g49g2000cwa.googlegroups.com...
> Hi:
> Is the maintenance plan correct ?
> 1. Perform DBCC CheckDB on Saturday 8:00PM
> 2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
> every 15 minute, from Monday to Friday and Saturday will start on
> 8:00AM to 4:00AM
> 3. Database Full backup will start on 9:00PM from Monday to Friday and
> Saturday will backup on 4:00PM.
> 4. System will remove the transaction log backup which is more than 4
> days.
> 5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
> use script to rebuild the index, so that only the fragmented index file
> will be rebuild)
> Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
> minute, from Monday to Saturday.
> Will the replication cause the rebuild index fail ? Can transaction log
> backup and rebuild index happen at the same time ? I'm afraid the log
> file will grow too large during rebuilt index if i don't perform trx
> log backup.
> Please Advice
> Thanks
> JCVoon
>|||Hilary Cotter
Regarding point 5, I'm running an index rebuild, there will be no
operation after 8:00PM
I'm rely on the transaction log backup to minimise the log file grow
during rebuild index, is it possible ?
And for full database backup, the transaction log backup may trigger
during full database backup, is there any side effect ?
The rebuild index and full database backup, which should come first ?
any side effect if the full database backup and rebuild index happen at
the same time ? because i've time overlap on the full database backup
and rebuild index.
Thanks for your help.
Regards
JCvoon
Need adviceon SQL Server 2000 Maintenance Plan
Hi:
Is the maintenance plan correct ?
1. Perform DBCC CheckDB on Saturday 8:00PM
2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
every 15 minute, from Monday to Friday and Saturday will start on
8:00AM to 4:00AM
3. Database Full backup will start on 9:00PM from Monday to Friday and
Saturday will backup on 4:00PM.
4. System will remove the transaction log backup which is more than 4
days.
5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
use script to rebuild the index, so that only the fragmented index file
will be rebuild)
Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
minute, from Monday to Saturday.
Will the replication cause the rebuild index fail ? Can transaction log
backup and rebuild index happen at the same time ? I'm afraid the log
file will grow too large during rebuilt index if i don't perform trx
log backup.
Please Advice
Thanks
JCVoonRegarding point 5, do you mean you are running an index defrag? An index
rebuild is on offline operation which will mean the tables will go offline
as the index is being rebuilt. For large tables or if you are a 24x7 shop
this is probably not what you want. An index defrag will cause your tlogs to
ballon considerably, so you might want to shrink them somewhat after the
defrag.
Replication is not impacted by index defrags or rebuilds. Lengthy rebuilds
will cause the tlogs to grow, but you can dump them in the middle of a
rebuild.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1136456692.089320.162270@.g49g2000cwa.googlegroups.com...
> Hi:
> Is the maintenance plan correct ?
> 1. Perform DBCC CheckDB on Saturday 8:00PM
> 2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
> every 15 minute, from Monday to Friday and Saturday will start on
> 8:00AM to 4:00AM
> 3. Database Full backup will start on 9:00PM from Monday to Friday and
> Saturday will backup on 4:00PM.
> 4. System will remove the transaction log backup which is more than 4
> days.
> 5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
> use script to rebuild the index, so that only the fragmented index file
> will be rebuild)
> Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
> minute, from Monday to Saturday.
> Will the replication cause the rebuild index fail ? Can transaction log
> backup and rebuild index happen at the same time ? I'm afraid the log
> file will grow too large during rebuilt index if i don't perform trx
> log backup.
> Please Advice
> Thanks
> JCVoon
>|||Hilary Cotter
Regarding point 5, I'm running an index rebuild, there will be no
operation after 8:00PM
I'm rely on the transaction log backup to minimise the log file grow
during rebuild index, is it possible ?
And for full database backup, the transaction log backup may trigger
during full database backup, is there any side effect ?
The rebuild index and full database backup, which should come first ?
any side effect if the full database backup and rebuild index happen at
the same time ? because i've time overlap on the full database backup
and rebuild index.
Thanks for your help.
Regards
JCvoon
Is the maintenance plan correct ?
1. Perform DBCC CheckDB on Saturday 8:00PM
2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
every 15 minute, from Monday to Friday and Saturday will start on
8:00AM to 4:00AM
3. Database Full backup will start on 9:00PM from Monday to Friday and
Saturday will backup on 4:00PM.
4. System will remove the transaction log backup which is more than 4
days.
5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
use script to rebuild the index, so that only the fragmented index file
will be rebuild)
Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
minute, from Monday to Saturday.
Will the replication cause the rebuild index fail ? Can transaction log
backup and rebuild index happen at the same time ? I'm afraid the log
file will grow too large during rebuilt index if i don't perform trx
log backup.
Please Advice
Thanks
JCVoonRegarding point 5, do you mean you are running an index defrag? An index
rebuild is on offline operation which will mean the tables will go offline
as the index is being rebuilt. For large tables or if you are a 24x7 shop
this is probably not what you want. An index defrag will cause your tlogs to
ballon considerably, so you might want to shrink them somewhat after the
defrag.
Replication is not impacted by index defrags or rebuilds. Lengthy rebuilds
will cause the tlogs to grow, but you can dump them in the middle of a
rebuild.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1136456692.089320.162270@.g49g2000cwa.googlegroups.com...
> Hi:
> Is the maintenance plan correct ?
> 1. Perform DBCC CheckDB on Saturday 8:00PM
> 2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
> every 15 minute, from Monday to Friday and Saturday will start on
> 8:00AM to 4:00AM
> 3. Database Full backup will start on 9:00PM from Monday to Friday and
> Saturday will backup on 4:00PM.
> 4. System will remove the transaction log backup which is more than 4
> days.
> 5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
> use script to rebuild the index, so that only the fragmented index file
> will be rebuild)
> Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
> minute, from Monday to Saturday.
> Will the replication cause the rebuild index fail ? Can transaction log
> backup and rebuild index happen at the same time ? I'm afraid the log
> file will grow too large during rebuilt index if i don't perform trx
> log backup.
> Please Advice
> Thanks
> JCVoon
>|||Hilary Cotter
Regarding point 5, I'm running an index rebuild, there will be no
operation after 8:00PM
I'm rely on the transaction log backup to minimise the log file grow
during rebuild index, is it possible ?
And for full database backup, the transaction log backup may trigger
during full database backup, is there any side effect ?
The rebuild index and full database backup, which should come first ?
any side effect if the full database backup and rebuild index happen at
the same time ? because i've time overlap on the full database backup
and rebuild index.
Thanks for your help.
Regards
JCvoon
Need adviceon SQL Server 2000 Maintenance Plan
Hi:
Is the maintenance plan correct ?
1. Perform DBCC CheckDB on Saturday 8:00PM
2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
every 15 minute, from Monday to Friday and Saturday will start on
8:00AM to 4:00AM
3. Database Full backup will start on 9:00PM from Monday to Friday and
Saturday will backup on 4:00PM.
4. System will remove the transaction log backup which is more than 4
days.
5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
use script to rebuild the index, so that only the fragmented index file
will be rebuild)
Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
minute, from Monday to Saturday.
Will the replication cause the rebuild index fail ? Can transaction log
backup and rebuild index happen at the same time ? I'm afraid the log
file will grow too large during rebuilt index if i don't perform trx
log backup.
Please Advice
Thanks
JCVoon
Regarding point 5, do you mean you are running an index defrag? An index
rebuild is on offline operation which will mean the tables will go offline
as the index is being rebuilt. For large tables or if you are a 24x7 shop
this is probably not what you want. An index defrag will cause your tlogs to
ballon considerably, so you might want to shrink them somewhat after the
defrag.
Replication is not impacted by index defrags or rebuilds. Lengthy rebuilds
will cause the tlogs to grow, but you can dump them in the middle of a
rebuild.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1136456692.089320.162270@.g49g2000cwa.googlegr oups.com...
> Hi:
> Is the maintenance plan correct ?
> 1. Perform DBCC CheckDB on Saturday 8:00PM
> 2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
> every 15 minute, from Monday to Friday and Saturday will start on
> 8:00AM to 4:00AM
> 3. Database Full backup will start on 9:00PM from Monday to Friday and
> Saturday will backup on 4:00PM.
> 4. System will remove the transaction log backup which is more than 4
> days.
> 5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
> use script to rebuild the index, so that only the fragmented index file
> will be rebuild)
> Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
> minute, from Monday to Saturday.
> Will the replication cause the rebuild index fail ? Can transaction log
> backup and rebuild index happen at the same time ? I'm afraid the log
> file will grow too large during rebuilt index if i don't perform trx
> log backup.
> Please Advice
> Thanks
> JCVoon
>
|||Hilary Cotter
Regarding point 5, I'm running an index rebuild, there will be no
operation after 8:00PM
I'm rely on the transaction log backup to minimise the log file grow
during rebuild index, is it possible ?
And for full database backup, the transaction log backup may trigger
during full database backup, is there any side effect ?
The rebuild index and full database backup, which should come first ?
any side effect if the full database backup and rebuild index happen at
the same time ? because i've time overlap on the full database backup
and rebuild index.
Thanks for your help.
Regards
JCvoon
Is the maintenance plan correct ?
1. Perform DBCC CheckDB on Saturday 8:00PM
2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
every 15 minute, from Monday to Friday and Saturday will start on
8:00AM to 4:00AM
3. Database Full backup will start on 9:00PM from Monday to Friday and
Saturday will backup on 4:00PM.
4. System will remove the transaction log backup which is more than 4
days.
5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
use script to rebuild the index, so that only the fragmented index file
will be rebuild)
Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
minute, from Monday to Saturday.
Will the replication cause the rebuild index fail ? Can transaction log
backup and rebuild index happen at the same time ? I'm afraid the log
file will grow too large during rebuilt index if i don't perform trx
log backup.
Please Advice
Thanks
JCVoon
Regarding point 5, do you mean you are running an index defrag? An index
rebuild is on offline operation which will mean the tables will go offline
as the index is being rebuilt. For large tables or if you are a 24x7 shop
this is probably not what you want. An index defrag will cause your tlogs to
ballon considerably, so you might want to shrink them somewhat after the
defrag.
Replication is not impacted by index defrags or rebuilds. Lengthy rebuilds
will cause the tlogs to grow, but you can dump them in the middle of a
rebuild.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1136456692.089320.162270@.g49g2000cwa.googlegr oups.com...
> Hi:
> Is the maintenance plan correct ?
> 1. Perform DBCC CheckDB on Saturday 8:00PM
> 2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs
> every 15 minute, from Monday to Friday and Saturday will start on
> 8:00AM to 4:00AM
> 3. Database Full backup will start on 9:00PM from Monday to Friday and
> Saturday will backup on 4:00PM.
> 4. System will remove the transaction log backup which is more than 4
> days.
> 5. Rebuild index will start from 8:35PM to 10:59PM on every Friday. (I
> use script to rebuild the index, so that only the fragmented index file
> will be rebuild)
> Note: Replication will start from 8:00AM to 8:30PM, occurs every 15
> minute, from Monday to Saturday.
> Will the replication cause the rebuild index fail ? Can transaction log
> backup and rebuild index happen at the same time ? I'm afraid the log
> file will grow too large during rebuilt index if i don't perform trx
> log backup.
> Please Advice
> Thanks
> JCVoon
>
|||Hilary Cotter
Regarding point 5, I'm running an index rebuild, there will be no
operation after 8:00PM
I'm rely on the transaction log backup to minimise the log file grow
during rebuild index, is it possible ?
And for full database backup, the transaction log backup may trigger
during full database backup, is there any side effect ?
The rebuild index and full database backup, which should come first ?
any side effect if the full database backup and rebuild index happen at
the same time ? because i've time overlap on the full database backup
and rebuild index.
Thanks for your help.
Regards
JCvoon
Subscribe to:
Posts (Atom)