Viewing 15 posts - 7,666 through 7,680 (of 49,552 total)
Also check with the network admin to ensure there are no firewalls in the way.
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
September 28, 2014 at 10:50 am
The message posted said to check the latest errorlog for the last messages and fix whatever those messages said was wrong. So, I'm asking what were those messages and what...
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
September 28, 2014 at 10:41 am
plamannkathy (9/28/2014)
Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion
What did you find when...
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
September 28, 2014 at 8:55 am
All you had to do was kill the tape backup task, offline the DB and bring it online again. Detaching wasn't at all necessary. If you'd looked in the SQL...
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
September 28, 2014 at 7:41 am
To be honest, I'd recommend you rebuild the system databases and then re-apply logins, linked servers, jobs, etc. There's a reason why it is strongly not recommended to restore 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
September 28, 2014 at 4:33 am
It means that log segments can't be reused because of replication. Doesn't necessarily mean replication is the only reason, just that replication is a reason.
Btw, deleting a log file...
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
September 28, 2014 at 4:32 am
Again......
If you want the DB readable between restores, why are you not restoring WITH STANDBY?
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
September 27, 2014 at 4:28 am
Once you RESTORE ... WITH RECOVERY you cannot restore any more backups. Recovering a database finishes the recovery process and brings it online and usable.
If you need to restore another...
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
September 26, 2014 at 10:50 am
But your where clause is not checking for a date range. It's checking for a string range. All three values are varchar, so you're getting string comparisons. Remove the CONVERT...
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
September 26, 2014 at 7:36 am
Drop the CONVERT.
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
September 26, 2014 at 7:29 am
Don't give them the SA login. Create a login for them which has exactly the permissions you want them to have and no more.
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
September 26, 2014 at 7:19 am
The sa account is sysadmin, cannot be removed from that role. You cannot deny anything to a sysadmin. Someone with the sysadmin role can do anything to a SQL instance,
p.s....
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
September 26, 2014 at 6:39 am
Could anyone with a moment please check my answer here: http://www.sqlservercentral.com/Forums/Topic1618884-391-1.aspx
Want to make sure there's no small inaccuracy which could get exploited.
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
September 26, 2014 at 5:22 am
You don't need to flush the cache.
An ALTER PROCEDURE invalidates the procedure's plan as it is. Wiping every single other query's and procedure's plan out of cache as well is...
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
September 26, 2014 at 5:19 am
It's also violating software design practices. A stored proc is supposed to return one thing, like a method does in your OO languages. You're asking about a procedure that, depending...
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
September 26, 2014 at 4:01 am
Viewing 15 posts - 7,666 through 7,680 (of 49,552 total)