April 18, 2012 at 5:58 am
Generally in Web Application, database backup and restoring the same database if required can be done manually for single client or organization.
But in Single Instance Multi - tenant Architecture where some time number of database can grow more than 5,000 to 10,000 or more and taking backup manually is cumbersome.
So how to manage automated backup and restoring of database if required, for such large number of small Databases.
April 18, 2012 at 6:27 am
Your best bet is write a script that will do all the databases. You can use sp_foreachdb, which is just a cursor, to run a command on all databases.
Alternatively, you can use the Maintenance Plans, but don't run auto-shrink. You'll get a lot more control from a script.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 18, 2012 at 8:15 am
You can also use Ola Hallengren's script for backups which will cover all or select databases.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply