Link to home
Start Free TrialLog in
Avatar of WNC1
WNC1

asked on

SQL 2005 Best Way to Backup Database

We have a Server 2008 OS running Microsoft SQL 2005. What is the best way to stop the SQL database and make a backup of the log file? It is only 1 database from a software called AIM. We want this automated so it can run nightly without us having to do anything. We are using Syncback for the backup process to our Server.
Avatar of WNC1
WNC1

ASKER

We went though SQL to make the backup a few minutes ago. We noticed that it would only allow the backup to go to the C: Drive of the Server. Is there anyway to change that? The C: drive only has 30GB free, so 2 or 3 backups would fill that up. We were going to backup the database to a mapped drive on another server, but when selected the location we can only pick the C: Drive. Is this a limitation of SQL 2005?
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
True, not a mapped drive, but any drive that is validly available to SQL.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial