Viewing 15 posts - 18,766 through 18,780 (of 49,552 total)
GilaMonster (4/26/2012)
You have to wait for it to finish.If you kill the process again it will show you the rollback completion % and estimated time.
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
April 26, 2012 at 10:28 am
Wait for it to finish the rollback.
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
April 26, 2012 at 7:27 am
The string "$(runDate)" is not a valid date. And that's not a function or anything, that's a literal string "$(runDate)"
What are you trying to do?
Also, this
if 'TODAY' != upper ('$(runDate)')
...
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
April 26, 2012 at 7:24 am
Look up CAST or CONVERT.
btw, we prefer that new questions get asked in a new thread. Keeps things cleaner.
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
April 26, 2012 at 7:16 am
You have to wait for it to finish.
If you kill the process again it will show you the rollback completion % and estimated time.
What exactly was the process that you...
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
April 26, 2012 at 7:15 am
Yup, that's the problem. There's a space missing between the end of the collation name and the word 'primary'
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
April 26, 2012 at 7:05 am
The log reader doesn't copy transactions to the distributor's log. It copies them to the distributor database.
Other than that, pretty much. That's how transactional replication works. Changes are marked as...
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
April 26, 2012 at 6:05 am
That code runs fine and without any error on my SQL 2008 server. Sure it's that exact piece of code that's causing the error?
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
April 26, 2012 at 6:03 am
Wait. It's rolling back and has to finish the rollback. Don't restart SQL, that will just result in the rollback continuing after the restart, possibly with the database offline.
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
April 26, 2012 at 6:01 am
Licensing is about paperwork, the SQL instances themselves don't know how they are licensed. As Satheesh said, the license type is supposed to be null, it is not registered within...
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
April 26, 2012 at 6:01 am
Once you start replication, any new transactions are marked as 'to be replicated' and need to be picked up and copied by the log reader before the log can be...
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
April 26, 2012 at 5:10 am
Firstly, changing the recovery model to full because the log is large is a inappropriate thing to do. The log gets automatically marked as reusable in simple recovery model, in...
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
April 26, 2012 at 4:27 am
Jan Van der Eecken (4/25/2012)
GilaMonster (4/25/2012)
... (for a PASS abstract)...Does that mean you're going to the Summit after all?
It means I'm submitting abstracts, that's all.
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
April 26, 2012 at 3:36 am
All the cert exams for 2008 are around 3 hours long.
Use the material for the non-upgrade exams for the cert you are looking for.
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
April 26, 2012 at 3:33 am
WayneS (4/25/2012)
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
April 26, 2012 at 3:32 am
Viewing 15 posts - 18,766 through 18,780 (of 49,552 total)