sqlhelp Posted October 30, 2015 Report Posted October 30, 2015 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 Posted October 30, 2015 Report Posted October 30, 2015 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 Posted October 30, 2015 Author Report Posted October 30, 2015 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 Posted October 30, 2015 Report Posted October 30, 2015 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 Posted October 30, 2015 Report Posted October 30, 2015 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
Recommended Posts