Viewing 15 posts - 6,901 through 6,915 (of 9,244 total)
This link details the requirements
It states as follows
Books Online
Creating a new mirror database minimally requires taking a full backup of the principal database and a subsequent log backup and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2011 at 2:45 am
You're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:57 pm
Your best route are the scripts above!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:55 pm
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:20 pm
Link here 😉
😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:17 pm
This should get you started
SET NOCOUNT ON
--Check if the temp table exists, if it does cleanup!
IF (object_id('tempdb..#sysdbs')) IS NOT NULL
BEGIN
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:10 pm
perfectly ok for the 2 to co exist
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:01 pm
SQL7 databases may be directly attached\restored to SQL Server 2005 with no step between. When upgrading to SQL Server 2008 you would need to go through either SQL Server 2000...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 1:48 pm
logicinside22 (7/14/2011)
created clusterdc , node1,node2 virtual machine names on VMware.
Allocated 15GB hard drive...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 1:41 pm
If mirroring in a workgroup use this article to help you set it up
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" 😉
July 14, 2011 at 1:27 pm
You asked
yoffes (7/14/2011)
What are the least set of permissions that will allow this?
Granting at the table object level is least permission, granting at schema is greater scope!
This looks neater
yoffes (7/14/2011)
GRANT...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 1:15 pm
validate and cleanse the column data in the source table
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 12:51 pm
Grant select, insert, update, delete on object::dbo.test2 to testrole
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 11:01 am
to configure mirroring for a workgroup see the following blog post
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" 😉
July 14, 2011 at 6:54 am
GilaMonster (7/13/2011)
Honestly, I'd be taking backups and mirroring the backups.
I'm with Gail here, I think this would be the best solution
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 3:56 am
Viewing 15 posts - 6,901 through 6,915 (of 9,244 total)