Viewing 15 posts - 4,891 through 4,905 (of 9,253 total)
query the sysjobs table in the MSDB database for the info you need
October 5, 2012 at 2:01 am
Well done, thanks for posting back
October 4, 2012 at 11:43 pm
Generally I think that experience is a better measuring stick, sure you'll have exceptions but overall experience counts.
October 4, 2012 at 11:42 pm
lptech (10/4/2012)
But you'd have to make sure that you issue the 'with move' while you restore the log with the add file command.
You are correct. When you are aware...
October 4, 2012 at 4:54 pm
I dont use it as its a pile of doggy doo doo 🙂
What options are you using during the copy?
October 4, 2012 at 4:40 pm
Jpotucek (10/4/2012)
Another dumb question.
There are never dumb questions, only ever dumb answers 😉
Jpotucek (10/4/2012)
October 4, 2012 at 4:34 pm
As DNS is AD integrated it can take a short time to replicate across DCs. Remember you're dealing with a multi master replication model here and it gets even worse...
October 4, 2012 at 4:26 pm
A great one is
"it's late and you're rebooting the SQL Server but it's taking forever to shutdown and restart, why shouldn't you hold the power button for 4 secs to...
October 4, 2012 at 12:27 pm
TJ-356724 (10/4/2012)
The mirror will be using asychn.
This only alters the way the data is committed between the Principal and Mirror.
TJ-356724 (10/4/2012)
October 4, 2012 at 12:06 pm
Windows 2003 or Windows 2008 domain?
Each virtual network name would be registered in Active Directory and would also have a DNS host (A) record created.
Is your DNS zone AD integrated?
Do...
October 4, 2012 at 11:59 am
TJ-356724 (10/4/2012)
October 4, 2012 at 9:43 am
Jpotucek (10/4/2012)
I am in stalling SQL Server 2008 R2 Standard Edition and I would like to Slipstream in the latest Service Pack and CU Package.
I tested this successfully with...
October 4, 2012 at 9:07 am
On the 2008 server make sure to run DBCC CHECKDB WITH DATA_PURITY this will check for any column to data mismatches, which it sounds like you have here.
Perform a select...
October 4, 2012 at 8:30 am
In a typical replication topology the Publisher and Subscriber are separate physical machines, probably with large distances between them.
You can integrate the Publisher and Distributor on the same instance but...
October 4, 2012 at 7:50 am
TJ-356724 (10/4/2012)
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'AssignmentRoot' (ID 1286229770). Missing or invalid key in index 'idx_AssignmentRoot_RepName' (ID 70) for the row:
Server: Msg...
October 4, 2012 at 7:26 am
Viewing 15 posts - 4,891 through 4,905 (of 9,253 total)