Viewing 15 posts - 3,121 through 3,135 (of 49,552 total)
A copy-only backup is a full backup, it should initialise the log chain without problems, as the only difference to a non-copy only is that the copy only doesn't reset...
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
May 4, 2016 at 4:53 am
Ray K (5/3/2016)
So what can you do to alleviate this situation? What steps can you take to minimize your weaknesses and, instead, leverage your strengths?
Know a little about 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
May 3, 2016 at 3:37 pm
jasona.work (5/3/2016)
GilaMonster (5/3/2016)
jasona.work (5/3/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
May 3, 2016 at 3:22 pm
jasona.work (5/3/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
May 3, 2016 at 12:33 pm
cookiemonstagt (5/3/2016)
Lynn Pettis (5/3/2016)
cookiemonstagt (5/3/2016)
So why they need to bk up those files?
They are system databases required by SQL Server to run correctly. Without 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
May 3, 2016 at 10:38 am
cookiemonstagt (5/3/2016)
.. thanks and one last question if the db is shared each node has these 3 files to be able only to run 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
May 3, 2016 at 10:17 am
You can't stop a database. You'd need to stop the entire clustered database instance (and no, not from services either)
Please, get someone who knows what they're doing to do whatever...
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
May 3, 2016 at 10:04 am
bustell (5/3/2016)
Is there a way to get the history of statistics update?
Not unless you have some manual process that's been keeping track of it.
I would suggest you track that query'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
May 3, 2016 at 9:40 am
No. You have no rights at all.
If you restart the SQL service in single user mode and connect as that single user, then and only then is a local administrator...
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
May 3, 2016 at 9:37 am
They're the system databases for the SQL Server instance. Without them, SQL is toast, it won't even start.
And you shouldn't be copy-pasting them. That's not how SQL backups are taken....
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
May 3, 2016 at 9:36 am
There are very, very, very few stats, perfmon, SQL or other, that have a single defined threshold value, whether it be universal or just for your server.
There is 'normal 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
May 3, 2016 at 9:22 am
The service will only be running on one node, that's the definition of active and passive nodes. That said, the system databases are on a shared drive, there's one copy...
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
May 3, 2016 at 9:17 am
PSB (5/3/2016)
I want the CST time recorded . If I don't do a -5 then May3rd, 7pm would be inserted as May 4th,00 am .
If the server is running 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
May 3, 2016 at 8:14 am
Titles are meaningless. My current title is "Technical Lead". Doesn't tell you a damn thing about the technologies I work with.
Microsoft doesn't set titles, they create technology.
The DBA job (and...
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
May 3, 2016 at 3:08 am
Rod at work (5/2/2016)
However in my testing I noticed that if I set it to what it already is, the UPDATE() function says I've modified it.
The UPDATE function has nothing...
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
May 2, 2016 at 2:16 pm
Viewing 15 posts - 3,121 through 3,135 (of 49,552 total)