Viewing 15 posts - 8,326 through 8,340 (of 9,720 total)
I disagree with everyone. This will affect your backup. Because I don't see anywhere in your plan where you're backing up the transaction log.
Unless Log Shipping has seriously changed, you...
May 18, 2009 at 4:51 am
Are you trying to send a Service Broker email or just an email to some end users with DBMail? It makes a difference on what you troubleshoot.
May 18, 2009 at 4:48 am
Find yourself a long query. Change the connection timeout properties of your DEV server so that it will force a time out. Create your alert. Run your query. That should...
May 18, 2009 at 4:47 am
rajganesh.dba (5/18/2009)
May 18, 2009 at 4:45 am
I think the only way to do this is to use Profiler or run a trace against your system. But this will only give you a snapshot in time. It...
May 18, 2009 at 4:40 am
Hate to say it, but I believe the backup chain was broken when the Recovery Mode was reset. This is probably why you can't continue with the log restores.
My advice...
May 18, 2009 at 4:37 am
This sounds suspiciously like a homework or test question. We don't answer those on this site. It shouldn't be too hard for you to find the answer. Look up MDX...
May 18, 2009 at 4:35 am
rudy komacsar (5/15/2009)
Here are a couple of backup options ...- LiteSpeed
- Striping - http://www.sqlservercentral.com/Forums/Topic704434-357-1.aspx
Not quite what I'm talking about, Rudy. @=)
Though the striping could be used as part of the...
May 15, 2009 at 7:58 am
I don't have specific links, but check out Backup in Books Online or Google "Backing up SQL Server", "Backup VLDB SQL Server", things like that.
The problem is, because everyone's...
May 15, 2009 at 7:18 am
Your backup strategy may need to be revisited at this point too. If you're still using the "small DB backup" strategy, it's probably taking a ton of maintenance time.
Regardless, if...
May 15, 2009 at 5:53 am
Roust_m (4/29/2009)
Too much manual work. ... I really can't use these options.
Well if everything we suggest is too much work, then I'm afraid we can't help you.
Sorry.
April 30, 2009 at 4:04 am
You're welcome. And thanks for the luck.
Let me know whether or not this does what you're wanting.
April 29, 2009 at 12:04 pm
Bad joins between the Dimension tables and the Fact tables. Depends on whether you're getting too many records or not enough records.
Check your table relationships.
April 29, 2009 at 11:27 am
Right click Cubes, go to New Cube and, in the Wizard, choose "Build the cube without using a data source". Then you can generate a schema and do something...
April 29, 2009 at 11:24 am
Aha. Just found out there are still columns in my pre-aggregated tables that can be grouped and measured on.
Nevermind. @=)
April 29, 2009 at 11:21 am
Viewing 15 posts - 8,326 through 8,340 (of 9,720 total)