Viewing 4 posts - 1 through 4 (of 4 total)
If you db is in FULL recovery model then make sure log backup should be running else log will be growing like anything.and if log backup is not required then...
May 4, 2011 at 5:09 am
#1319643
Ok suppose i have to ceate a DR solution for a instance whihc has more than 100 dbs and b sizes is approx upto 30-40 gb.cost is not a constraint...
March 8, 2011 at 6:56 am
#1295830
You have 3 options:
Replication
Logshipping
Database mirroring with database snapshot
Choose anyone for reporting.....ut yes again Trasactional Replication would be best option here
July 19, 2010 at 2:03 am
#1194737
run below cmd:
ALTER DATABASE SET ONLINE
June 30, 2009 at 1:37 am
#1017403