Viewing 15 posts - 6,121 through 6,135 (of 9,241 total)
Thanks for clearing that up
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2012 at 9:28 am
IIRC the older syntax is not supported in database compatibilty modes of 90 and higher
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2012 at 9:19 am
To set up mirroring in a workgroup see the following link
http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2012 at 8:07 am
Is your laptop part of a windows domain. You need to be able to provide and resolve FQDNs?
To setup mirroring in a workgroup you need to take a different approach...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2012 at 7:12 am
winston Smith (1/8/2012)
I tried to set up mirroring. I restored my backup to the mirror and left it in a NO RECOVERY state.
You must take and restore at least one...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2012 at 6:23 am
winston Smith (1/8/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2012 at 5:12 am
See my reply to your last post on this subject
http://www.sqlservercentral.com/Forums/Topic1205594-1526-2.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2012 at 2:39 am
Also, Depending on the size of the disk you may want to consider using GPT over MBR.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2012 at 2:35 am
See, what I like about the Oracle and VMWare certs is the fact you can't just go take an exam off your own back. You have to attend an approved...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2012 at 2:22 am
As I pointed out on your last post you made on this topic, you only need the backup of the database and the backup of the certificate. Books online details...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2012 at 2:10 am
In my opinion outsourcing is fine for small companies who don't want the hassle of managing technologies directly.
Larger companies should always look to retain their systems in house. I have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2012 at 5:24 pm
So instance A and B were running under separate user accounts, correct?
Are you moving a TDE protected database from one instance to another?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2012 at 5:12 pm
DIB IN (12/30/2011)
Data has been Encrypted using Key. Now we restore the database back-up to a new server.
Are you usIng transparent data encryption?
DIB IN (12/30/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2012 at 5:06 pm
GilaMonster (1/7/2012)
I count no more than an intern straight out of school that braindumped his way through a single SQL certification.
Sadly this is so true, it renders the certification and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2012 at 4:43 pm
Small indexes (I.e. few pages) are scattered because the pages fill in gaps in used extents. It's likely the database engine would incur extra I\O to move pages to make...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 11:24 am
Viewing 15 posts - 6,121 through 6,135 (of 9,241 total)