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 |
|
mruprai
Starting Member
12 Posts |
 Posted - 2012-10-15 : 15:26:53
|
| I have a 2 db. One for Mi, I want to copy to the mi database(from the 1st db) and then create indexs specific to the MI db.I have sql server 2008 r2.What's the easiest way to do this. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-10-15 : 17:36:04
|
| Backup and Restore I guess. Your question isn't really clear.-Chad |
 |
|
|
v_yaduvanshi
Starting Member
11 Posts |
Posted - 2012-10-16 : 03:54:36
|
Hi,if its regular practice, you can use COPY DATABASE wizard and schedule it as per your requirement.quote:
Originally posted by mruprai
I have a 2 db. One for Mi, I want to copy to the mi database(from the 1st db) and then create indexs specific to the MI db.I have sql server 2008 r2.What's the easiest way to do this.
Virendra YaduvanshiMCTS, MCITP SQL Serverhttp://wikidba.wordpress.com/ |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-10-17 : 20:09:32
|
| You could set up Snapshot Replication to run on a daily basis. As part of the replication configuration turn off the copy of the indexes at the Article level but also define a post-snapshot script that would run to create the MI specific indexes that you want.=================================================We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry |
|
|
|
|
|
|
Schedule copy of db then add index