Viewing 15 posts - 1,036 through 1,050 (of 1,583 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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 1, 2012 at 12:32 am
A dumb question I'm sure....did you manually run the snapshot agent?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 31, 2012 at 12:09 pm
I did try this, and was able to successfully start it
Start SQL with the /f parameter and traceflag 3608 on.
eg net start mssqlserver /f /T3608
however,
Connect to SQL via the DAC...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 31, 2012 at 11:41 am
Viewing 15 posts - 1,036 through 1,050 (of 1,583 total)