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
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
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
run below cmd:
ALTER DATABASE SET ONLINE
June 30, 2009 at 1:37 am
Viewing 4 posts - 1 through 4 (of 4 total)