May 18, 2011 at 3:22 pm
Version: MSSQL 2008 R2, MSVS 2005, ASP.net 2.0
Set up: On a hoster in a VPS setup.
How can I setup a automatic back up run? Do I use stored procs or do you do it some other way, or does the hosting service run back up for my database for me ?
Whats the best way to get back ups run for a asp.net 2 website on a VPS environment?
May 18, 2011 at 4:05 pm
Can you create jobs in sql agent?
May 18, 2011 at 4:08 pm
YES in the VPS you can..
May 18, 2011 at 4:21 pm
May 18, 2011 at 4:39 pm
Thanks.
Ok I run the back up daily.
With what frequency do I run or should I at all run Integrity check and index optimization.
And what about this code that I run daily, should I use it:
DBCC SHRINKDATABASE ('myDB',10);
ALTER INDEX ALL ON DIM_myTable REORGANIZE
May 18, 2011 at 5:16 pm
Digs (5/18/2011)
Thanks.Ok I run the back up daily.
With what frequency do I run or should I at all run Integrity check and index optimization.
And what about this code that I run daily, should I use it:
DBCC SHRINKDATABASE ('myDB',10);
ALTER INDEX ALL ON DIM_myTable REORGANIZE
Backup daily
tlog 15 minutes (or however much data you're prepared to lose)
Check DB daily.
Index daily with http://sqlfool.com/2010/04/index-defrag-script-v4-0/
Never shrink in a job. It cancels out the work you did in reindex and slows down performance overall
May 18, 2011 at 5:36 pm
Thanks for this link
http://sqlfool.com/2010/04/index-defrag-script-v4-0/
But I cant work out where to install it..
Do I install it on myDB (main database), or do I install it in a myTestDB and direct it to myDB to check ??
It does not specify installation needs?
Do you use it, if so where did you install it?
May 18, 2011 at 5:58 pm
Install it in master. It will work all the databases by default.
May 20, 2011 at 5:39 am
How about creating a maintenance plan ?
Personally, not a massive fan of maintenance plans but at the same time will do everything you need.
May 20, 2011 at 5:59 am
vultar (5/20/2011)
How about creating a maintenance plan ?Personally, not a massive fan of maintenance plans but at the same time will do everything you need.
I can't even recount the bugs in those not to mention that ther are dangerous in the untrained hands!
May 20, 2011 at 7:10 am
Just a suggestion! As I said, I don't use them myself..
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply