I have SQL server 7.0 in my company. The drive space allocated for the server is 18 Geg. It has only about 3 geg free space. 8 geg of the used space has backup files. I'm thinking to move the back up files to another drive to free up space. Is it posible to just cut the files and paste them in a different drive? Will this damage the data? Or what is the best way to free up more space?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Moving Backup files to another drive
- Thread starter shaminda
- Start date
As long as the backup file is NOT ACTIVELY in use by SQL Server, yes - you may drag and drop the file to a new directory; and the directory may be on a different drive - on a different array. If you don't change the target backup destination for the 'next' backup -- that's ok. SQL Server will dynamically create the backup in the original location. If you need to restore the newly located backup file, simply tell SQL (via the FROM DEVICE keywords) where the new location/file is!!
Hope this helps...
Bill Turner
Hope this helps...
Bill Turner
- Status
Similar threads
- Locked
- Question