Viewing 15 posts - 17,326 through 17,340 (of 49,552 total)
Log backups will fail until a full or differential backup is taken.
Please read through this - Managing Transaction Logs[/url]
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
July 31, 2012 at 3:53 am
pradeep.mohan (7/31/2012)
We are planning to mirroring totally 1000 databases to our DR site. I want know approximately how much bandwidth and disk size (Each database is 8 GB) is required.
No...
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
July 31, 2012 at 3:23 am
At the subscriber, that foreign key already exists somehow so the replication can't create it. Drop or rename the one in the subscriber database.
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
July 31, 2012 at 3:21 am
Take more frequent log backups or extend the disk.
Please read through this - Managing Transaction Logs[/url]
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
July 31, 2012 at 1:56 am
It's not repairable. The damage is in the system tables
I suggest you export all the data that you can from the tables that you can query (bcp out or similar)...
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
July 31, 2012 at 1:54 am
Start with the following:
What is absolutely required of this person, what do they need to know very well?
What do they need to have a general understanding of? (I can fail...
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
July 30, 2012 at 5:11 pm
Steve Jones - SSC Editor (7/30/2012)
well, as long as it's not deserted, and stocked with drinks, I vote for packing lots of books. Also currency to exchange for alcoholic drinks.
Loooots...
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
July 30, 2012 at 5:02 pm
opc.three (7/30/2012)
OP says they had 'max degree of par' set to 2. Does that change the split you mentioned?
Yes, but the specifics, not the general rule. Maxdop is per operator,...
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
July 30, 2012 at 4:58 pm
Lynn Pettis (7/30/2012)
Also, looking at what you posted above, this can be done without using dynamic sql.
Yup, but if it's a homework exercise on dynamic SQL, then the answer that'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
July 30, 2012 at 4:55 pm
SQLRNNR (7/30/2012)
GilaMonster (7/30/2012)
Steve Jones - SSC Editor (7/30/2012)
Hmmm, I go to SQL Saturday #144 and this thread goes from water cooler to technical discussion.
I'm sorry. Won't happen again.
Change topic: 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
July 30, 2012 at 4:49 pm
opc.three (7/30/2012)
I am puzzled as to how you could have seen 10 threads for SPID 100.
Two operators running with 4 threads, 2 co-ordinator threads. They won't all be running, only...
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
July 30, 2012 at 4:43 pm
Steve Jones - SSC Editor (7/30/2012)
Hmmm, I go to SQL Saturday #144 and this thread goes from water cooler to technical discussion.
I'm sorry. Won't happen again.
Change topic: What to do...
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
July 30, 2012 at 4:38 pm
Locked pages won't help.
You're getting mem_to_leave pressure. (the portion of the base 2GB that is reserved for thing like thread stacks, CLR, backup buffers, etc before the buffer pool 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
July 30, 2012 at 4:32 pm
Show us what you've tried. We don't do people's homework for them, we'll offer advice and suggestions.
Start with the hint given, how do you determine the first table alphabetically 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
July 30, 2012 at 2:27 pm
Administrative tools -> services. You can do both from there.
Why do you want to do this? Automatic doesn't means automatically restart, just automatically start when the server starts
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
July 30, 2012 at 1:12 pm
Viewing 15 posts - 17,326 through 17,340 (of 49,552 total)