I could not find the tools or scripts at the beginning. That makes me think why it is not there. Then I realized the reason could be why...

Idera SQLpermissions does the job. Just be aware of the new user/login has an empty password.

Interesting. But I do not see the attachment 😉

Does anyone here have rebuilt (not restore) system databases successfully? It is still a mystery for me.

http://www.sqlservercentral.com/Forums/Topic378850-146-1.aspx

Sounds reasonable. I like your “rebuild\reorg your indexes” part as well.

Thank you George. This clears my doubt. Bear with me one more question. How does SQL Server internally handle this?

John’s point is right. But...

A good solution George. Just wondering any impact on the current user activities while migrating all data from the specified file to other files.

I was thinking to suggestion a question to Steve. How many SQL instances/databases a DBA supports in average? I found this question is on today’s vote already. ...

xp_ServiceControl 'QueryState', 'SQLServerAgent'

works for both SQL 2000 and 2005.

Good to know this xp_.

Is this KB related to your 17883 error? http://support.microsoft.com/kb/928568

Dipali (4/15/2008)

---

As mentioned,

I need to add a new Cluster to an existing SQL 2005 Cluster which sits on top of a Windows 2003 Cluster. I referred to this microsoft document:

-->...

Log shipping or data mirroring. You can have either one of them with Clustering.

Check this earlier post http://www.sqlservercentral.com/Forums/Topic453480-146-1.aspx

Kimberly Tripp has 2 webcasts talking about data mirroring with...

A possible home grown process would be like this:

Set up a trace and configure it as per auditing requirement. Set up a daily job to have these kinds of...

Does this apply to your problem?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1980724&SiteID=1

2. How I can prepare failback in such case? Restore from SQL 2005 to sql 2000 is not possible but maybe we can set up replication from SQL 2005 to...