Viewing 11 posts - 46 through 56 (of 56 total)
Here are the details from the SERVERPROPERTIES
Principal:
Version9.00.3042.00
LevelSP2
Edition Enterprise Edition
Mirror:
Version9.00.4053.00
LevelSP3
EditionEnterprise Edition (64-bit)
May 6, 2010 at 2:38 pm
Digging a little deeper I have found the servers are running on different Service Packs. The Primary is x86 SP2. The Mirror is x64 SP3. Would the...
May 6, 2010 at 7:14 am
It is similar, and I did think about it, but it will not work in our company.
We have a lab in TX with equipment connected to the SQL DB thru...
January 7, 2010 at 3:56 pm
Yes, data is being written to both servers.
Lookup data will be easy to maintain with a SSIS job, it's the customer and order data that is the big issue. ...
January 7, 2010 at 11:26 am
On the nose! I completely forgot the Full Text Index. THANK YOU!!!!!!!
Every once in a while I have a serious brain fade and need the good old smack...
April 28, 2009 at 11:15 am
The log portion is only 463 MB, which is a little less than the physical size of the log. The total physical size has never exceeded 9GB.
Viewing the media...
April 8, 2009 at 11:19 am
No, the job overwrites the existing backup file. The file is backed up to tape by our netadmin @ ~Midnight.
Here are the job steps.
Step 1: Backup the DB
BACKUP DATABASE...
April 8, 2009 at 9:23 am
No errors are received, the database is just unresponsive. On both the principal and mirror. It's like it never finishes failing over.
October 2, 2006 at 12:18 pm
Yes.
We configured for high safety with a witness.
September 28, 2006 at 11:22 am
Our developers like to return the recordset to a table variable, then join the table variable to another table or view.
September 27, 2006 at 2:23 pm
Pro: GUID's can be replicated, Int's cannot.
September 27, 2006 at 2:12 pm
Viewing 11 posts - 46 through 56 (of 56 total)