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.
Author |
Topic |
DBLearner
Starting Member
1 Post |
Posted - 2004-10-12 : 01:41:28
|
Hello,I have been trying to take backup of my database , but all my efforts have been waste so far. The back up process seems to run fine, but no back up file is created. I used DB maintenance wizard and also tried right clicking on DB to take back up.Any help will be appreciated! |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-12 : 01:45:17
|
do not use maintenance wizard for backups. check the path you specified for the backup to be created. |
|
|
pyeoh
Starting Member
18 Posts |
Posted - 2004-10-12 : 02:11:39
|
I suggest you start off with something simple first using Query Analyzer e.gBACKUP DATABASE pubs TO DISK = '<local folder>/pubs.bak'and work from there. Refer to Books Online on the BACKUP command for all the other possible options.Peter Yeohhttp://www.yohz.comNeed smaller SQL2K backups? Use MiniSQLBackup Lite, free! |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-12 : 04:28:48
|
If you go down the route of rolling-your-own backups make sure you do some recovery tests over an extended period. There's quite a lot that the Wizzards do behind the scenes ... although the Wizzard as clearly written by a summer student at MS, with no supervision!This may help:http://weblogs.sqlteam.com/tarad/category/95.aspxKristen |
|
|
|
|
|