Viewing 15 posts - 391 through 405 (of 1,271 total)
Before you jump into restoring from a really old backup, try creating the database snapshot manually. If snapshot creation is successful, run CheckDB directly on the snapshot you created.
Let us...
November 21, 2011 at 12:18 pm
What if a failover occurs but the other node fails to come online and it fails back to the original server? No alert will be raised.
What if the cluster shuts...
October 5, 2011 at 10:31 pm
If your page file is large enough to support a full dump, it will perform a full dump every time. If you have a very large amount of RAM, this...
October 5, 2011 at 4:35 pm
First thing, a single transaction is better.
Secondly, I recommend renaming the old table instead of dropping immediately just in case.
Third, are there indexes, triggers, etc. that also need to be...
October 5, 2011 at 10:18 am
I'll be there. I'm doing a regular session, a panel discussion, a lightning talk, and a focus group.
September 28, 2011 at 10:33 am
Even though i got it right, I wasn't 100% sure that it wasn't answer C. Great information!
September 19, 2011 at 10:51 pm
What Edition are you using? What is the output of this query (replacing "DBName" with the name of your database)?
Use master;
Select name As [File Name],
type_desc As [File Type],
state_desc As...
September 12, 2011 at 9:56 am
I do not have a degree. I've taken quite a bit of college courses just on things that interest me (like physics and calculus -- yes, I'm a geek). I...
September 9, 2011 at 10:22 am
High Value mode? This question should have been listed under the humor category. The last two choices made me laugh! 😀
September 9, 2011 at 9:41 am
Good luck everyone (not really, but I want to get emails if posts are made to this forum 😀 )
September 1, 2011 at 10:18 am
You don't need to restore the log backups. Take a new differential backup and restore it on the secondary using the norecovery option. This will span the unrestored log and...
August 17, 2011 at 11:19 pm
Interesting. You can add the switches to the job directly as well.
August 17, 2011 at 2:13 pm
Just a hunch, but verify that the database has a valid owner. If the owner is not valid, you can get weird issues with permissions.
Select d.name, sp.name
From sys.databases d
Left Join...
August 17, 2011 at 12:48 pm
Any errors in the SQL Log or event log on publisher or distributor?
August 17, 2011 at 12:25 pm
Look in replication monitor to see if you see a better error. You could also try starting the agent from the command line to see if you get a better...
August 17, 2011 at 12:13 pm
Viewing 15 posts - 391 through 405 (of 1,271 total)