| Author |
Topic |
|
cshah1
Constraint Violating Yak Guru
347 Posts |
 Posted - 2009-01-02 : 12:35:57
|
| SQL Server 2005 SP2, Standard Edition I have created a DBAdmin user DB and created backup stored procedureIt is giving me following warning..Should I ignore this warning..?Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'master.dbo.xp_backup_database'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'master.dbo.xp_backup_database'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'master.dbo.xp_backup_log'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-01-02 : 12:50:54
|
| One more question, this is a production DB currently under simple recovery mode I am going to change recovery mode to Fulland will be doing daily full backup at 3 AM and Tran log backup at 8 AM, 2 PM and 8 PM.database is subject to moderage usage only during the 8 AM to 8 PM. Question: Should I take tran log backup every half or one hour? I know consequence with point in time recovery but is there any issue with doing tran log backup every hour (performance wise)?I already set up a job (weekly) that will going to remove backup history older than 30 days form MSDB. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-01-02 : 13:01:25
|
| Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-01-12 : 11:40:01
|
| Tara, I don't think your script does a backup checksum. Any reason(s) not to use it?after backup if we are doing a restore and running DBCC CHECKDB we probably do not need checksum. I think I answered my own question. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-01-12 : 14:57:33
|
| Backup checksum does not check the integrity of the database you are backing up.It is used to be able to do a more complete check of the integrity of the backup file to verify that the data in the backup file has not been corrupted since it was written to disk.CODO ERGO SUM |
|
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-03-12 : 10:05:55
|
| Tara, it appears to me that the script do not backup resource database.Do we really need to backup hidden but important resource database?Thanks, |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Tara your backup script