SQL 2000 - randomly stopped - file permissions


have sql 2000 database instance 4 databases. 2 fine, 2 randomly stopped. detached and reattached them , in "read-only" mode , when try change them writable file permission errors: help/hints appreciated:

i know old customer has process require 2000 version.  on 1 reattahced in 2008r2 , 1 apparently cannot moved.

title: microsoft sql server management studio

------------------------------

alter failed database 'mydatabase'.  (microsoft.sqlserver.smo)

------------------------------
additional information:

exception occurred while executing transact-sql statement or batch. (microsoft.sqlserver.connectioninfo)

------------------------------

device activation error. physical file name 'e:\mssql\data\mydatabase_data.mdf' may incorrect.
device activation error. physical file name 'f:\mssql\data\mydatabase_data_1' may incorrect.
device activation error. physical file name 'f:\mssql\data\mydatabase_data_1' may incorrect.
device activation error. physical file name 'g:\mssql\data\mydatabase_data_2' may incorrect.
device activation error. physical file name 'g:\mssql\data\mydatabase_data_2' may incorrect.
device activation error. physical file name 'h:\mssql\data\mydatabase_data_3' may incorrect.
device activation error. physical file name 'h:\mssql\data\mydatabase_data_3' may incorrect.
device activation error. physical file name 'i:\mssql\data\mydatabase_data_4' may incorrect.
device activation error. physical file name 'i:\mssql\data\mydatabase_data_4' may incorrect.
device activation error. physical file name 'j:\mssql\data\mydatabase_data_5' may incorrect.
device activation error. physical file name 'j:\mssql\data\mydatabase_data_5' may incorrect.
device activation error. physical file name 'k:\mssql\data\mydatabase_data_6' may incorrect.
device activation error. physical file name 'k:\mssql\data\mydatabase_data_6' may incorrect.
device activation error. physical file name 'l:\mssql\data\mydatabase_data_7' may incorrect.
device activation error. physical file name 'l:\mssql\data\mydatabase_data_7' may incorrect.
device activation error. physical file name 'm:\mssql\data\mydatabase_data_8' may incorrect.
device activation error. physical file name 'm:\mssql\data\mydatabase_data_8' may incorrect.
device activation error. physical file name 'n:\mssql\data\mydatabase_data_9' may incorrect.
device activation error. physical file name 'n:\mssql\data\mydatabase_data_9' may incorrect.
device activation error. physical file name 'q:\mssql\log\mydatabase_log.ldf' may incorrect.
device activation error. physical file name 'r:\mssql\log\mydatabase_log_1.ldf' may incorrect.
not restart database 'mydatabase'. reverting old status.
alter database statement failed.
device activation error. physical file name 'q:\mssql\log\mydatabase_log.ldf' may incorrect.
device activation error. physical file name 'r:\mssql\log\mydatabase_log_1.ldf' may incorrect. (microsoft sql server, error: 5105)

jb

so files exist on these paths?

right-click files, select security tab, advance button , there ownership tab, can change owner. make sure owner service account sql server.

if running , happens little green men in machine. or, more likely, process detaches files. check agent jobs , windows task scheduler.

erland sommarskog, sql server mvp, esquel@sommarskog.se



SQL Server  >  SQL Server Database Engine



Comments

Post a Comment

Popular posts from this blog

SQL server replication error Cannot find the dbo or user defined function........

hi there, i ran problem while deploying sql 2008 transactional replication between 2 servers lets assume server , b. actually created  both distributor , publisher on server , after created subscriber pointed server b, launch replication monitor , found big red cross. when click on tab "distributor subscriber history" error says "cannot find either column "dbo" or user defined-function or aggregate "dbo.ufnleadingzeros", or name ambiguous". can body regarding issue. regards, ishuv hi, you need compare data , others reseved, index size, unused should not compared. differs. here server - data - 87896 kb server b - data - 78152 kb server data size includes publication tables, can't compare directly. need check article article know exact data size. SQL Server  >  ...
Read more

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

Admin Permissions

hi need create new 'role' following permissions, 1. access sql server logs. 2. access maintenance plans ( can avoid access) 3. access activity monitor 4. normal access product databases , not system db´s need guidance on how it, can point me in right direction please? thanks 1.grant  execute on xp_readerrorlog [domainname\ad user or group]; 2. http://technet.microsoft.com/en-us/library/ms191002.aspx 3.view server state permission 4. make user member of dbo_owner database role. best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql consulting: large scale of database , data cleansing remote dba services: improves ms sql database performance sql server integration services: business intelligence SQL Server  >  ...
Read more