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

You asked

Granting at the table object level is least permission, granting at schema is greater scope!

This looks neater

yoffes (7/14/2011)

---

GRANT...

validate and cleanse the column data in the source table

Grant select, insert, update, delete on object::dbo.test2 to testrole

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

I'm with Gail here, I think this would be the best solution

subbkarth (7/14/2011)

---

In one of my production server scheduled a maintenance plan for rebuild index on 1 am.

suddenly i'm getting this error:

Here is the error

Executing the query "ALTER INDEX [work_package_calendar_work_package_IDX] ON...

or a differential 😉

If the 2 hourly backups are not managing the log sufficiently increase it to...

not something i have ever seen before, the databases will synchronise when they both restart.

Build yourself a couple of virtual machines and try it 😉

what issues are you expecting or considering??

SQL Server buffer pool is typically the largest memory consumer, have you accounted for this?

???????

All operations are rolled back anyway. Do what you must but there is no need to disable the jobs...

garfield81 (7/13/2011)

---

Planning on setting up mirroring for a SQL 2008 standard production server and I realize I need to restore the DB on the mirror server with NORECOVERY and then...

this link provides full details

SVR (7/12/2011)

---

Hi,

I am using sql server 2008 on win 2008. I restored a database from sql server 2000 to 2008, and also installed the application using...