Sql Server Question

[sqlhelp]

sql filename change help 

 

database ni offline chesi  filename alter  chesthe error vasthundi 

 

I am not moving the files  any help on this pl 

[electionszindabad]

Refer msdn ba. But ur method is right. Detach the database or set the database offline change the file and reset it back to online or attach the database. However physical name of the file needs to be changed at the OS level as well. So basically u need change both physical and logical file names

[sqlhelp]

Refer msdn ba. But ur method is right. Detach the database or set the database offline change the file and reset it back to online or attach the database. However physical name of the file needs to be changed at the OS level as well. So basically u need change both physical and logical file names

 

OS level ante file location lo rename cheyala ? 

 

I tried dettach / attach method too dint work 

[electionszindabad]

OS level ante file location lo rename cheyala ?

I tried dettach / attach method too dint work

Yes. File location. Xp_cmd shell use cheyyi. Google it.

[electionszindabad]

Yes. File location. Xp_cmd shell use cheyyi. Google it.

Move use cheyyi. Move command rai assign it to a varchar variable.
Something like this

Declare @cmd = 'move /y oldfile_path newfile_path'
Exec master..xp_cmdshell @cmd