Salut,
Lucrez pe un SQL Server 2005 SP1 Developer Edition. AM o baza de date "Test1" care initial a fost creata in cu filele mdf si ldf in "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data". Vreau sa mut filele in alta partitie. Am facut: detach la test1 din consola (m-am loginat cu sa) , apoi mutat filele pe alta partitie, apoi attach. Problema este ca imi apare baza de date ca fiind read-only. AM dat "alter database test1 set read_write", dar imi apare eroarea:
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "E:\work\sql\sqlserver2005\data\Test1.mdf". Operating system error 5: "5(Access is denied.)".
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "E:\work\sql\sqlserver2005\data\Test1_log.ldf". Operating system error 5: "5(Access is denied.)".
File activation failure. The physical file name "E:\work\sql\sqlserver2005\data\Test1_log.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 1
Database 'Test1' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Filele de pe e: au drept de scriere pe ele, idem folderul care le contine. De ce nu functioneaza? la fel imi da si daca intru cu windows authentication. Stiu ca pot face backup/restore, dar intrebarea ramane...
Lucian