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 |
|
powellbound
Starting Member
23 Posts |
 Posted - 2008-08-21 : 12:44:33
|
| We are looking to schedule our backups nightly at 2 am instead of doing them manually (I know, there was no IT staff at all 2 weeks ago).Anyway, I was curious what you all would recommend as a best practice to do this. I was planning on just setting up a job but thought I would ask the experts first.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
powellbound
Starting Member
23 Posts |
Posted - 2008-08-21 : 15:30:45
|
| When I the sql to create the sp, I got these messages: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.Obviously, I do not have that table. Do you have the DDL to create that table?Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-21 : 15:59:46
|
Did you notice in the blog where it says this:quote:
If you don't have SQL LiteSpeed installed, ignore the warnings in the output when creating this stored procedure. They are warnings and not errors. The stored procedure works with or without SQL LiteSpeed installed.
Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
powellbound
Starting Member
23 Posts |
Posted - 2008-08-21 : 16:09:57
|
| Hmmm, guess I missed that... ;)Thanks |
|
|
|
|
|
|
Backup Best Practices