[windows2000] Re: OT - SQL Server Question
- From: "James Lilly" <LillyJ@xxxxxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Mon, 27 Feb 2006 14:08:19 -0500
It depends on how it is setup. If you go into SQL Enterprise Manager, do you
have any database maintenance plans? If so, change the backup device
there.....if not, it's probably running as a SQL Server Agent job, and can be
pointing to a permanent or temporary backup device.
If it's a permanent device, you can find those listed in Enterprise Manager and
change the path. If it's temporary, you have to change the backup T-SQL to
point to the new location.....
Let me know if you need help changing these (or finding out which method you
are using).
Hope this helps;
James
From: rleach@xxxxxxxxxxxxxxx [mailto:windows2000@xxxxxxxxxxxxx]
Sent: Monday, February 27, 2006 10:56 AM
To: <windows2000@xxxxxxxxxxxxx>
Subject: [windows2000] OT - SQL Server Question
Please pardon the OT.
Due to disk space considerations I need to move the location of the backup file
(*.bak) for our SQL Server 2000 database.
I have Googled for this but seem to come up empty. My experience with SQL
server is limited and the help is appreciated.
Thanks
Ron
Other related posts:
