Re: DB Backup - Single User Mode

"velu5" <thirumalaivelu@xxxxxxxxx> wrote in message
news:1193743908.840076.37120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello ,

Is it possible/recommended to do SQL server instance backups in Single
user mode ?

Thanks in advance,
atv


It's possible. I can't think of a reason to recommend it unless you
especially needed to prevent any changes (for example if you were backing up
in advance of an upgrade or planning to decommission the original database).

--
David Portas


.

Relevant Pages

  • Re: DAW Configuration
    ... The biggest issue is always stability of the system and parts. ... The best advice I think I can give is: Invest in a good power supply, I won't run anything under 500Watts, and strongly recommend you do the same. ... It's just not worth the risk not buying a high end power supply, it's only a few dollars more and the gains in system stability under stress are substantial. ... The reason is simply that you want to reduce the work your primary HDD does by shifting part of the workload over to a second drive. ...
    (rec.audio.pro)
  • Re: Using Page Object in VB Class File
    ... No reason to recommend against modules. ... > go ahead and create a Public class with Public Shared subs and/or ... > Function MyFunction(ctl as Control) ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: smtp
    ... > I'm sure the MVPs around here are aware of this undocumented solution - but they don't ... > recommend it - and probably for good reason. ... The only reason to use that is if the smtp server needs authentication. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: windsurfing with TKR(total knee replacement}
    ... joint replacement and about 80% of that is total knee replacement. ... In general, after TKA, the two things we usally recommend against ... The main reason for this is that we resurface your patella ... Big wave sailing is probably not a great ...
    (rec.windsurfing)
  • Re: [9fans] dtrace for plan 9
    ... which queue up blobs of data up for userland code to do the hairy lifting ... Is there any reason that D couldn't always run in ... user mode, having read from a device which delivers events to it? ... a huge reduction in event traffic at a price of restricting D. Lack of looping ...
    (comp.os.plan9)