DR Question

We are planning for DR setup. Currently the database is located on shared disk storage. During DR, if we connect the database in the shared disk storage to the DR server. Will we be able to start up the SQL server at DR server? The IP address of the DR server will be different from the production since on different network segment. Is there any other things we need to take care of, such as user logins? Please comment.

If what is on the shared disk is your user(application) database, then you'll need to manually sync up all other data such as logins, stored procedures, maintenance jobs, etc.

They you would need to attach the database to the instance on the new node.

Downloading shared datasources

If there are multiple developers, can we download the shared data sources
that are stored on the server? Or does each report developer need to create
their own?
Thanks,Hey all the developers can use the same shared datasource but through VSS
then the reports can be well controlled.
Amarnath
"Mark" wrote:
> If there are multiple developers, can we download the shared data sources
> that are stored on the server? Or does each report developer need to create
> their own?
> Thanks,