Re: Move 10 DBs and provide dev access thru EM?
- From: "GaryB" <GaryB@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 17 Feb 2006 04:49:51 -0800
Thanx Dan,
That sorted the problem. It turned out to be failover software holdin the
DBs open. Stopped the service and all went well.
Thanx for your time
G
"Dan Guzman" wrote:
Detaching the database should free the files to be copied so you shouldn't.
need to stop SQL Server. You might try a utility like FileMon
(http://www.sysinternals.com/Utilities/Filemon.html) to see if you can spot
the process using the database files.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"GaryB" <GaryB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:48EA3BB7-C6DE-4FA0-A0CF-BB4135499D16@xxxxxxxxxxxxxxxx
Thanx Dan,
Have got the users sorted now, by adding roles as you suggested & it works
a
treat. I am having problems however with moving databases from C to D and
wondered if you could shed any light. I detached a database, then tried to
move it to the D Drive (240GB) but it claims the database is still in use
somewhere. I know this cant be true as I also tried with NorthWind and got
the same result. As a test I then tried to rename the logfile -
database_log.ldf but got the same message. Would it help if I actually
stopped the SQL service to do this (Live enviroment) or is there something
else?
I know my procedure is correct as I did this on a test server this morning
without any drama..
Thanx again
G
"Dan Guzman" wrote:
detaching the DBs moving them to D then
attaching seemed the option, but I tried this on a test server and the
DBs
lost permissions!
Permissions should not have been lost if you simply detached and
re-attached
to the same instance. I can see how you could run into issues if you
attached to a different instance due to mismatched logins/users, though.
Secondly, can I provide access to the databases for our developers
through
their local Enterprise manager as read only access? Do I need to create
user
roles in all databases or can I assign a single role and apply to all?
You'll need to grant the developers access to each database. The default
public role permissions will allow viewing schema and objects. You can
add
them to the db_datareader fixed database role in order to read data.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"GaryB" <GaryB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C9034D52-59AA-4590-B4B0-70573E10B140@xxxxxxxxxxxxxxxx
Hi,
We are running a live SQL2000 server with 10 dbs on the servers default
SQL
install location (C:\Programme Files\MSSQL\Data\etc). For various
reasons
I
want to move this location to the same servers D Drive and wondered if
anyone
could point me in the right direction how to achive this wihtout losing
permissions & more importantly data.. detaching the DBs moving them to
D
then
attaching seemed the option, but I tried this on a test server and the
DBs
lost permissions!
Secondly, can I provide access to the databases for our developers
through
their local Enterprise manager as read only access? Do I need to create
user
roles in all databases or can I assign a single role and apply to all?
Thanx for your time
G
- References:
- Re: Move 10 DBs and provide dev access thru EM?
- From: Dan Guzman
- Re: Move 10 DBs and provide dev access thru EM?
- From: GaryB
- Re: Move 10 DBs and provide dev access thru EM?
- From: Dan Guzman
- Re: Move 10 DBs and provide dev access thru EM?
- Prev by Date: Re: Permissions required to use Bulk Load with SQL Server 2005
- Next by Date: Re: SQL Injection with ADO parameters
- Previous by thread: Re: Move 10 DBs and provide dev access thru EM?
- Next by thread: ADO.NET Failed to load msxmlsql.dll
- Index(es):
Relevant Pages
|
Loading
