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  General SQL Server Forums  New to SQL Server Programming  New SQL servers - Backup help needed

Author  Topic  Sire Starting Member 1 Post Posted - 2009-07-01 : 17:37:32 Hi, I have been a network administrator for this small business for four years and they just recently migrated with another company. This new company has a larger network which has two different SQL servers. (SQL 2005 and SQL 2000) I took a Cisco class in college instead of SQL and now I am trying to learn SQL. I need help to make sure the backups are being done properly. It looks like daily backup are being done automatically but since I did not set them up I do not trust them. A new file everyday appears in the SQL Backup folder ranging back to 2007. I am unsure if it is a full backup or something else. Both databases are small only around 1GB. I tried setting up my own job script using the SQL management software to do a full backup everyday but only one file is being created and everyday that file double in size. I rather have it do one full backup each day, each with a different file. Questions: Is it possible to check what backups jobs and there settings are being done everyday on each database or SQL server? How do I setup a backup job or script for each database to make a full backup daily so that it makes a new file everyday? Also is there any book you recommend I read to learn more about SQL? I am new to SQL so detailed or simple explanations are welcomed as well as links to any guides that might help me. Thanks,