Viewing 15 posts - 8,326 through 8,340 (of 9,725 total)
SQL_Monster (5/18/2009)
The only thing i can do is backup and restore. But apart from that can't i restore or perform any backups on this db ?
Not quite sure what you...
May 18, 2009 at 7:48 am
Have you checked the mail server name? If the SMTP mail server isn't working, then SQL Server would queue the emails and not realize anything is wrong.
Also, it could be...
May 18, 2009 at 5:11 am
I'm not missing detail values so much as the details are even aggregated. I know that sounds odd, but that's the way it is. Say you have an order with...
May 18, 2009 at 5:07 am
I agree with Lynn. Unless you're experiencing serious space issues, leave it alone. I've had this problem several times myself and usually it's a valid process. Only on rare occasions...
May 18, 2009 at 5:01 am
By the By, your restore plan for the main server (assuming you use FULL, Differential & Transaction Log backups) will need to be as follows:
Restore the most recent FULL, restore...
May 18, 2009 at 4:55 am
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
Viewing 15 posts - 8,326 through 8,340 (of 9,725 total)