May 28, 2013 at 7:38 am
When I put order by cluase, I found something there is one database it stops taking backup and after that any database it doesn't take i.
May 28, 2013 at 8:34 am
Instead of using a cursor directly against sys.databases, try putting the rows into a #temp table first. Also, try adding FAST_FORWARD option to the cursor just to be sure.
If you have the time to explore another more reliable option, look at the backup solution provided at http://ola.hallengren.com.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 28, 2013 at 8:54 am
Thank you for reply
But my script has mix recovery model databases there is 4 or 5 databases have Simple recovery model and rest of them is full recovery model it that makes any difference?
May 28, 2013 at 9:05 am
Ola's solution takes all of that into account. You can have it backup only certain databases, and it supports full, differential and log backups too. Have a look and post back if you have specific questions about how to use it.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply