Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-08-10 : 19:39:27
|
| Hi thereI got couple question that you might give some light about the following SQL2000 issue:1. When you do a db restore, I would like to know the progress of restore. How do I do this? I know that it's using STATS but if you run this backup TSQL under job. I won't be able to see this progress under the job history?!?!2. We are using Maintenace Plan to create a job for BACKUP. By default, this creates an suffix ISO date at end of backup name plus keeping the database only 3 days for instance which are good feature. If I want to create this similar thing that we can do just run a normal job with TSQL or I need another job to handle keeping 3 days backup.3. When we looked at the backupset table under MSDB db, there are field called backup_start_date and backup_finish_date. I realise this information especially for backup_finish_date that is not really corresponding the actual finish backup. Where I can found this information then?I'm appreciated your comment.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-10 : 19:45:08
|
| 1. That is true. Perhaps you could still use WITH STATS and output that to a file so that you could open it up during the restore.2. Here's my replacement code for maintenance plans. It (isp_Backup) allows you to specify the retention period to keep the files on disk.http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx3. I don't have time right now to track down the specific table in MSDB to answer your question. Take a look at the various backup tables in that database and use SQL Server Books Online to find the answer if no one else comes up with it here.Tara Kizer |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-08-11 : 01:14:50
|
Hi thereThat blog is very useful. Thanks for that. I had a question regading these scripts (isp_DBCC_CHECKDB, isp_DBCC_INDEXDEFRAG, isp_DBCC_DBREINDEX etc). Any reason why it recommended to store into Admin database instead of master database?Thanksquote:
Originally posted by tkizer
1. That is true. Perhaps you could still use WITH STATS and output that to a file so that you could open it up during the restore.2. Here's my replacement code for maintenance plans. It (isp_Backup) allows you to specify the retention period to keep the files on disk.http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx3. I don't have time right now to track down the specific table in MSDB to answer your question. Take a look at the various backup tables in that database and use SQL Server Books Online to find the answer if no one else comes up with it here.Tara Kizer
|
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2006-08-16 : 11:21:52
|
| Tara -Just an FYI, the isp_Backup (full db backup) fails to backup dbs with spaces on the database name, mistake we did back in the newbie days, thank god there's only one db like that on our system.---Thanks!Igor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-16 : 12:28:43
|
quote:
Originally posted by valdyv
Hi thereThat blog is very useful. Thanks for that. I had a question regading these scripts (isp_DBCC_CHECKDB, isp_DBCC_INDEXDEFRAG, isp_DBCC_DBREINDEX etc). Any reason why it recommended to store into Admin database instead of master database?Thanksquote:
Originally posted by tkizer
1. That is true. Perhaps you could still use WITH STATS and output that to a file so that you could open it up during the restore.2. Here's my replacement code for maintenance plans. It (isp_Backup) allows you to specify the retention period to keep the files on disk.http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx3. I don't have time right now to track down the specific table in MSDB to answer your question. Take a look at the various backup tables in that database and use SQL Server Books Online to find the answer if no one else comes up with it here.Tara Kizer
Master belongs to Microsoft. If ever I need to restore their database from scratch, I don't want to have to remember which objects I placed in there.Tara Kizer |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-16 : 12:30:42
|
quote:
Originally posted by igorblackbelt
Tara -Just an FYI, the isp_Backup (full db backup) fails to backup dbs with spaces on the database name, mistake we did back in the newbie days, thank god there's only one db like that on our system.---Thanks!Igor.
Yes I am aware of that. However, I refuse to fix it. Objects should not have spaces in them whether they be databases, tables, views, etc... It's a pet peeve of mine. You can easily get around this issue if you put square brackets around the database name.Tara Kizer |
|
|
|
|
|
|
|
|
Couple Question regarding DB Admin