Viewing 15 posts - 31 through 45 (of 372 total)
SQLRNNR (3/28/2014)
Ed Wagner (3/28/2014)
RowRoe
Wade
March 28, 2014 at 7:31 am
I have production issues I need to deal with and will post your requested information as soon as I can free up.
Kurt
March 27, 2014 at 7:50 am
You execute a script like this either directly as a SQL Server Agent job or you can create a Maintenance Plan and run the SQL within it. You would...
March 27, 2014 at 7:49 am
GilaMonster (3/26/2014)
You're absolutely sure there aren't somehow multiple backups appended in the same file? (since you're using noinit on the backup)
Absolutely!
March 26, 2014 at 9:05 am
GilaMonster (3/26/2014)
What are the exact versions of the two servers?SELECT @@Version
Any traceflags enabled on either server?
no traceflags.
Production server:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
Jun 28...
March 26, 2014 at 8:56 am
GilaMonster (3/26/2014)
Should created the DB exactly as it was at the time of the backup. Nothing else going on? No reverts from snapshot? No data obfuscations being run?
Can...
March 26, 2014 at 8:35 am
GilaMonster (3/26/2014)
Edit: Native backups? What's the backup command? What's the restore...
March 26, 2014 at 8:25 am
EricEyster (3/24/2014)
Ed Wagner (3/24/2014)
BWFC (3/24/2014)
LonelyIsolation
Island
Hopping
March 24, 2014 at 10:01 am
Revenant (3/20/2014)
Kurt W. Zimmerman (3/20/2014)
TomThomson (3/20/2014)
crookj (3/20/2014)
Ed Wagner (3/20/2014)
Stuart Davies (3/20/2014)
BWFC (3/20/2014)
Ed Wagner (3/19/2014)
crookj (3/19/2014)
Revenant (3/19/2014)
Ed Wagner (3/19/2014)
SQLRNNR (3/19/2014)
parsenameQuotename
Delimiter
Pipe
Plumbing
Depths
Charge
Cash
Dough
Bread
Truckin'
Keep
fortified
March 20, 2014 at 1:59 pm
TomThomson (3/20/2014)
crookj (3/20/2014)
Ed Wagner (3/20/2014)
Stuart Davies (3/20/2014)
BWFC (3/20/2014)
Ed Wagner (3/19/2014)
crookj (3/19/2014)
Revenant (3/19/2014)
Ed Wagner (3/19/2014)
SQLRNNR (3/19/2014)
parsenameQuotename
Delimiter
Pipe
Plumbing
Depths
Charge
Cash
Dough
Bread
Truckin'
March 20, 2014 at 11:20 am
That reminds me of yet another position I had. They had some code that had been around for a very long time. I believe it originated on a...
March 19, 2014 at 1:56 pm
+1 on Jeff's comments as well. This topic of bad code seems to be cropping up more and more. If I had the best of all worlds I'd...
March 19, 2014 at 12:24 pm
It has been a while since I had a DB with a FTI, but from time to time I found it to report incorrect results despite the Auto-Index was on....
March 18, 2014 at 7:34 am
Viewing 15 posts - 31 through 45 (of 372 total)