Viewing 15 posts - 1,036 through 1,050 (of 1,584 total)
You need to research the true nature of the error. Login failure errors aren't going to tell you the problem, in fact I believe every login error (whether it...
August 2, 2012 at 9:34 pm
Also prolly good to know
C - OS, reporting services, general software
D - Main Data files
F - Index Files and some TempDB files
T - Log files
August 2, 2012 at 9:22 pm
I would recommend replication for the Dupes and Log Shipping for the Main Backup. This is under the assumption that the Main Backup server is intended to be a...
August 2, 2012 at 1:35 pm
Create a proxy account for agent execution
...make that the default owner for all jobs. This will still allow your permissions to work for the groups that need them, and...
August 1, 2012 at 10:37 am
You would restore Saturdays full backup, Wednesdays differential backup from 10am, and then the 10:30, 11, 11:30, 12, 12:30, 1p, 1:30, 2, 2:30, 3, 3:30, 4, and finally your 4:30p...
August 1, 2012 at 12:55 am
What did your server crash?
1 - Restore Saturday's Full Backup (with no recovery)
2 - Restore last Differential Backup (also with no recovery)
3 - Restore all the Transaction Log Backups...
August 1, 2012 at 12:38 am
Like others have said, it depends on your configuration...
Logshipping is very easy to do and you can place the DB's in stand-by mode (which will disconnect users when the logs...
August 1, 2012 at 12:32 am
A dumb question I'm sure....did you manually run the snapshot agent?
July 31, 2012 at 8:36 pm
If you aren't aware of the hardware, I'd personally opt for restoring 1 db at a time. In the long run it may be quicker...
July 31, 2012 at 7:56 pm
It "is" possible...but your primary limitation (depending on the size of the 10 DB's) most likely will be network IO and disk limitations/contention on the server.
Restoring 10 DB's at the...
July 31, 2012 at 7:18 pm
In my desperate time of need, thanks to all who jumped in to help - it's always good to know that this forum has members willing to step up and...
July 31, 2012 at 7:14 pm
GilaMonster (7/31/2012)
Cannot drop certificate '##MS_AgentSigningCertificate##' because there is a user mapped to it.
This was the culprit.
Started Server in command mode with trace flags -T902 and -T3601 (this avoided the...
July 31, 2012 at 7:09 pm
Unfortunately EVERYTHING is trying to connect to this server...
I opened two command windows, started the service in one and immediately alt-tabbed over to connect in the other (both windows have...
July 31, 2012 at 12:29 pm
FYI, I edited the error log file data and removed the failed login things and a few other status messages that did not seem overly important - hopefully this helps...
July 31, 2012 at 12:09 pm
Viewing 15 posts - 1,036 through 1,050 (of 1,584 total)