Viewing 15 posts - 2,206 through 2,220 (of 49,552 total)
SeanNerd (10/20/2016)
Any ideas?
Good luck. 🙂
Incredibly difficult (and not limited to LOB columns, same thing can happen with normal tables). And, what about the old backups from before the mistake was...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2016 at 5:13 pm
aaron.reese (10/20/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2016 at 5:00 pm
ram302 (10/20/2016)
What if I create a transaction on the table and leave it uncommitted, will this cause a timeout in the script when trying to connect?
No. That'll just leave...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2016 at 8:05 am
Table definitions please, at the very least, sample data would be very useful too.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2016 at 7:48 am
Please don't post multiple threads for the same question. From the other thread:
GilaMonster (10/20/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2016 at 4:27 am
If SSAS is on one server and SQL on another, both servers need to be licensed, you can't use the same license for the two servers. If you split the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2016 at 4:09 am
Create a second schedule for each of those jobs that runs on the 1st Monday of the month at something like 4:15 (give time for SQL and SQL Agent to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2016 at 4:00 am
suchita0805 (10/15/2016)
Having no backup of the database ..
JasonClark (10/19/2016)
So before going to restore your database you must verify the back health using restore verifyonly.
Um.... Can't exactly verify something that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2016 at 3:57 am
Can you post the full output of CheckDB?
All I can tell you from what you posted is that you're going to lose data fixing this (and without a backup, checkdb...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2016 at 3:56 am
Lynn Pettis (10/18/2016)
Need a crystal ball or a contractor.
Send the crystal ball over here when you're done please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2016 at 3:31 pm
SQL Guy 1 (10/18/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2016 at 3:26 pm
Weird...
Can you try to run CheckDB on that snapshot that you manually created?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2016 at 12:13 pm
SQL Guy 1 (10/18/2016)
Yes, I can easily create a snapshot on that database on a test server (haven't tried on production), even if other sessions connected to it.
That's not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2016 at 11:41 am
What language is that?
Where do you get the numbers that need to be replaced and the numbers that replace them?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2016 at 4:33 am
What is that from? spj is not a T-SQL function, so not SQL Server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2016 at 4:11 am
Viewing 15 posts - 2,206 through 2,220 (of 49,552 total)