[SQL Server Data Warehousing] Hai all,

Manish,Thank you so much.

I have one more question,

how do we refresh a database? is it that at once we refresh only one db at a time or we can refresh multiple db's at once?

so can u plz explain the process of refreshing database?

 

Raj,

You are welcome and thanks for visiting MSDN forum,

how do we refresh a database.

This following thread discussed about the same http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/d8b6990f-e851-4015-90a4-7b751d6b80a6

Its up to you, if you want to refresh occasionally you can do it manually for a single DB by following certain steps, else you can have automated scripts for multiple DBs too.

Please refer http://weblogs.sqlteam.com/tarad/archive/2009/02/25/How-to-refresh-a-SQL-Server-database-automatically.aspx

---

Thanks
Manish

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

.

social.technet.microsoft.com/Forums