Viewing 15 posts - 6,211 through 6,225 (of 9,253 total)
better option would be to use scripted T-SQL jobs, the BACKUP DATABASE command has a MIRROR TO clause which can be used to mirror backups. A lightweight VB script can...
December 13, 2011 at 10:59 am
this question has been raised before, yes it is possible but there are caveats around it
December 12, 2011 at 6:57 am
Hi sorry, my bad totally missed the cluster part. Yes for a new clustered instance you will need to add another root drive and letter to the new application group
December 9, 2011 at 10:46 am
kellithompson (12/9/2011)
December 9, 2011 at 8:20 am
Pierre Boucher (12/8/2011)
- Should I allocate multiple files for each FILEGROUP so that our SAN can distribute the I/O?
It's not a given, and in fact for user databases...
December 9, 2011 at 2:25 am
if you only want to keep one log file you dont have a choice which one, you must keep the log file with file id of 2, delete all others...
December 9, 2011 at 1:53 am
Here's the MS resource for Windows 2008 MSDTC
December 7, 2011 at 9:04 am
its no longer enforced but i implement it for the following reason
you have NodeA and NodeB and the clustered sql server instance uses the virtual network name CLUSNODE1, it is...
December 7, 2011 at 8:34 am
if you're unsure then open the Litespeed console and step through the backup or restore process for your chosen database. At the end of the wizard, before executing, there is...
December 7, 2011 at 4:58 am
Dude Dev
please accept my apologies 😉
On a side note the other thing that will commonly interrupt the log shipping is a manual transaction log backup that is not part of...
December 7, 2011 at 4:05 am
MyDoggieJessie (12/2/2011)
About 300 miles
😀
you want to try 6000miles 😎
December 6, 2011 at 2:48 pm
Dev (12/6/2011)
Perry Whittle (12/6/2011)
Dev (12/5/2011)
It sounds OK. Just make sure once you enable jobs they restore the backups in proper sequence (without breaking the chain).
Log shipping...
December 6, 2011 at 2:28 pm
adrian-844207 (12/3/2011)
None of the servers is in a domain.
so how come your script above references server1.ourdomain.com and server2.ourdomain.com
If setting up mirrroring in a workgroup please see the following article
http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx
December 6, 2011 at 1:53 pm
Dev (12/5/2011)
It sounds OK. Just make sure once you enable jobs they restore the backups in proper sequence (without breaking the chain).
Log shipping will automatically restore the logs...
December 6, 2011 at 1:55 am
SQLRNNR (12/5/2011)
With SSRS 2008, no IIS involved.
No IIS management console, but SSRS 2008 still uses the same HTTP.SYS driver that IIS would use
😉
December 6, 2011 at 1:50 am
Viewing 15 posts - 6,211 through 6,225 (of 9,253 total)