Backup location change - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Backup location change

Author

Topic

sqlserverdbam
Yak Posting Veteran

54 Posts

Posted - 2009-03-16 : 22:15:31

Hi,

I had SQLSERVER 2005 running.Sysamdin was trying to upgrade system and screwed up.Due to this Database was restored from old backup(Just attached).I'm running third part products.Vendor suggested to restore master and msdb Database also. I did master and msdb DB restored succssfully. All jobs came backup.Due to some architecture change.I want to move all backup from F: drive to G:drive.
Here is one backup job details:
Backup Database [Impact] TO [Impact] WITH INIT, NOUNLOAD, Name = N'Impact Full backup With Init', SKIP,
STATS = 10, NOFORMAT;
EXEC sp_MSforeachtable @command1 = "sp_recompile '?'"

Please advice.

sqlserverdbam
Yak Posting Veteran

54 Posts

Posted - 2009-03-17 : 13:10:37

Any thoughts?

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-17 : 13:13:04

impact is virtual device. change this path to whatever you want in SSMS

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources