Viewing 15 posts - 2,056 through 2,070 (of 2,756 total)
We're required to comply with the DoD STIG guides for our systems, and one of the requirements is "data files containing sensitive information must be encrypted" and "SQL Server must...
August 7, 2014 at 10:14 am
What a way to come back from a long(-long) weekend...
The other DBA (more a developer with DBA knowledge) in trying to get a bunch of Sharepoint DBs backed up to...
July 11, 2014 at 8:08 am
In a pinch, yes, you can attach the MDF / LDF and have a working database.
An example situation would be if say the OS crashed hard, you booted the server...
June 26, 2014 at 8:31 am
I'm with Jeff, and I'd toss in a few other suggestions as well...
First, pick up or download (hey, it's free!) a copy of "Troubleshooting SQL Server A guide from the...
June 26, 2014 at 8:07 am
Ed Wagner (6/20/2014)
Stuart Davies (6/20/2014)
BWFC (6/20/2014)
AtheistMuse
Beckett
Castle
June 20, 2014 at 9:21 am
Short answer:
Nope.
😀
Long answer:
The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full. If you had a full...
June 19, 2014 at 12:07 pm
Ed Wagner (6/19/2014)
SQLRNNR (6/19/2014)
Stuart Davies (6/19/2014)
Sean Lange (6/19/2014)
SQLRNNR (6/19/2014)
JAZZ Master (6/19/2014)
SQLRNNR (6/19/2014)
Ed Wagner (6/19/2014)
crookj (6/19/2014)
Ed Wagner (6/19/2014)
djj (6/19/2014)
Ed Wagner (6/19/2014)
crookj (6/19/2014)
Ed Wagner (6/19/2014)
Stuart Davies (6/19/2014)
rhythmk (6/19/2014)
Stuart Davies (6/19/2014)
BWFC (6/19/2014)
MethodTechnique
Procedure
Stored
Function
Script
Visual Basic
Visual...
June 19, 2014 at 10:22 am
Quite possible, and relatively easy to do.
Just keep this guide handy:
http://msdn.microsoft.com/en-us/library/ms143799(v=sql.105).aspx
and you shouldn't have any problems.
Of course, you also need to change the connection on the workstations, which depends on...
June 18, 2014 at 12:29 pm
Well, the log results are in, and the cause of the time increase?
The Index rebuilds. They're around 1/2 (maybe a bit more) of the total time for the SSIS...
June 18, 2014 at 6:56 am
Koen Verbeeck (6/18/2014)
jasona.work (6/18/2014)
Figured it was a glitch on our network here...It was a glitch in the matrix, Neo.
That explains the deja-vu when I saw the same person walk past...
June 18, 2014 at 6:38 am
Koen Verbeeck (6/18/2014)
jasona.work (6/18/2014)
Figured it was a glitch on our network here...It was a glitch in the matrix, Neo.
That explains the deja-vu when I saw the same person walk past...
June 18, 2014 at 6:38 am
I wonder if some of the site problems are due to the influx of soccer (OK, OK, futball... OK, OK, football) spam?
Yesterday I had the "site-in-the-site" thing (yes, IE9)...
June 18, 2014 at 6:24 am
GilaMonster (6/17/2014)
Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others""No pressure to work overtime" they say. :ermm:
Gotta love...
June 18, 2014 at 6:23 am
So, according to the customer, the application usage is right on-line with their historical rates, so it's not had a lot of churn, comparitively. The full backups have been...
June 17, 2014 at 9:18 am
Viewing 15 posts - 2,056 through 2,070 (of 2,756 total)