Viewing 15 posts - 22,786 through 22,800 (of 49,552 total)
sqlguy-736318 (10/22/2011)
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 22, 2011 at 12:37 pm
See Jonathan's blog series:
p.s. As a consultant, accepting work that you don't know how to do is not a particularly good idea. Mess up and that's a client that won't...
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 22, 2011 at 11:17 am
caspersql (10/22/2011)
Many thanks for the advice. I tried to do the following, not sure that I'm doing what you suggested right:
- Start / Run / cmd
- Typed...
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 22, 2011 at 11:11 am
Firstly, a weekly update is likely far from adequate to keep stats updated and query plans optimal, unless those tables only have a few rows changing per day.
As for 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 22, 2011 at 10:36 am
Just note that it will impede them, not completely prevent them from getting access. If someone has local admin rights and are determined enough (and knowledgeable enough) they'll still 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
October 22, 2011 at 10:32 am
No, you have to connect to SQL to change the log settings. There's a traceflag that lets SQL just start master up, no other database.
Start SQL (from the command line)...
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 22, 2011 at 10:25 am
sqlguy-736318 (10/21/2011)
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 22, 2011 at 7:11 am
Shark Energy (10/22/2011)
You see I can browse to the drives in question so they are there, but SQL clearly has a moment that it thinks they are not.
If SQL tries...
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 22, 2011 at 6:14 am
No evidence that the data is corrupt, but a lost log can also destroy a DB (had 2 cases of that this month so far)
It looks like a connection issue,...
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 22, 2011 at 5:28 am
When you create the logins on the mirror server, create them with the same SID as on the principal.
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 22, 2011 at 5:01 am
Not the SQL instance. Your database.
Sounds like there's a connectivity problem between the server and the log drive. If SQL can't find it's log file, it will throw errors,...
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 22, 2011 at 4:58 am
Spam. Reported. No replies 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 22, 2011 at 4:56 am
Error messages?
By 'share', do you mean a network share? An iSCSI target? Another SAN?
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 22, 2011 at 4:53 am
Depends on the size of the database, maintenance window length, restore requirements and a few other things.
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 22, 2011 at 4:52 am
dva2007 (10/22/2011)
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 22, 2011 at 4:51 am
Viewing 15 posts - 22,786 through 22,800 (of 49,552 total)