Yes you can. That would be like a scale out deployment. If you are not sure what is ment by that here is a link that explains it.

http://technet.microsoft.com/en-us/library/ms159114.aspx

Yes that is what you will need to do. When you configure server C you will just point to the existing Database. And no it should not do any thing...

Dave you can restore a copy only database backup using the GUI in SSMS. just do the following.

1. after clicking on restore database, select from device.

2. Click on the ellipis...

There are a lot of good articals on encrypting connection strings. Try looking at some of these.

http://www.codeguru.com/csharp/.net/net_security/encryption/article.php/c9699__1/

http://groups.google.com/group/a-c-net/browse_thread/thread/cab3d7cf6d778057

You could set up an alert using error number 3041. That one is for when a backup fails.

If I understand you right, you said the database server is not part of the domain. If that is the case the you can not use windows Authenication. You would...

Hey just tried it in 2008 you can run queries using the central management server against 2005 and 2000 as long as you don't use some thing that is not...

I would say go the same way as you did with access. And let the rules you put in you application determine if it is a valid user or not....

What did the encryption script look like? Also did you think about using the other keys to encrypt your keys instead of a password for each. By encrypting say your...

There are ways to get the same effect as schema security in 2000 but Since you are using Iron Speed I would say your options are limited. One way to...

in SQl it is the Builtin admins account that should be removed also.

First if that person does not need access to SQL then add their nt account to SQl and do a deny access on them. Even if they are in a...

If you are putting it on the report server then it should be an RDL not an RDLC.

http://msdn.microsoft.com/en-us/library/ms252109(VS.80).aspx

You could encrypt the data that way they could not add to it or change it. This would not stop them from deleting it though. There is no way to...

I know this was not the question you asked but I am wondering if you now are just getting ready to do this why you are using SQL 2000 since...