Before moving the files

1.take all the current files location

2.take all the DB backups.

rockingadmin (3/24/2010)

---

finally, which one is the best way to work around

1. script the file name,location and change the location with alter statement.

2.script to backup and restore in new location.

3.manually moving...

Can you post the exact error message.

isuckatsql (3/23/2010)

---

I am logged in as an administrator and each time i run the following query

exec master.dbo.xp_cmdshell 'dir c:\users\administrator.mydomainname\desktop\resumes\*.*'

I get an 'Access is denied' error!

This worked fine on my...

george sibbald (3/23/2010)

---

I don't agree backup\restore is safest way, a restore that fails leaves a database unusable, plus there is the database owner issue.

what could be safer than amending sys.master_files...

DBA_1276 (3/23/2010)

---

Hi all,

We need to move our production sql server 2005 to 2008,pls give the steps we need to do,and what are the things we need to check.

pls help me....

John Mitchell-245523 (3/23/2010)

---

This is one way of...

conor.devlin,

Do you want the data for reporting propose (Read only)?

rockingadmin (3/23/2010)

---

hi

i have 400 database in one sever. all the data and log files are stored in one drive. now i want to change the file location...

Read the gail's article http://www.sqlservercentral.com/articles/64582/

DBA_1276 (3/23/2010)

---

Hi all,

We need to move our production sql server 2005 to 2008,pls give the steps we need to do,and what are the things we need to...

Or just run this -- sp_help 'fn_trace_gettable'

JMSM (3/2/2010)

---

Hello,

I've run a profiler into a trace file 'D:\Traces\Troubleshoot-TRACES.trc' but when i insert all data in a table the following error appears.

Note: The code of the table and insert...

Thamizh (3/2/2010)

---

Hi all,

Any one give some word about this,If i run the procedure in test server it performs good.The same implement in the production server running very slow .I...

Also,

What's your sql server version?

What's your cluster type?