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 Administration
 SQL backup

Author  Topic 

MustardDave
Starting Member

2 Posts

Posted - 2011-05-06 : 11:37:21
Hi All,

Not only am I 'noob' but not really perhaps as experienced as I should be on this subject...

Essentially my database has been moved to SQL server 2008 and I am looking for an easy way to back it up!

When I try and copy the file it tells me that the file is in use and cant be copied.... :-(

Is there a way that it can be backup whilst in use? and how would I go about setting a schedule to do it regularly?

Thanks very much for your help and sorry if it is a basic question.

Dave

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-05-06 : 11:42:01
Use the BACKUP command to do database backups in SQL Server: http://msdn.microsoft.com/en-us/library/ms186865.aspx

Never rely on copying data and log files for backups, as you discovered they don't always work.
Go to Top of Page

MustardDave
Starting Member

2 Posts

Posted - 2011-05-06 : 11:51:04
Thanks for the swift response.!

Dave
Go to Top of Page
   

- Advertisement -