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 |
|
anitha2324
Starting Member
18 Posts |
 Posted - 2008-04-25 : 12:19:47
|
| Hi all, any one help me to make schedule for taking the back up for the databse in sqlserver 2000 ( daily backup on specified time like 12 midnight every day and it should be in the same file ) |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-25 : 12:25:00
|
| Use maintenance plan wizard and specify your schedule and locations and enable job. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-25 : 21:53:52
|
| You can find how to create sql job and backup syntax in books online. |
|
|
|
JCAlexandres
Starting Member
5 Posts |
Posted - 2008-04-30 : 10:07:29
|
Just out of curiosity ... why do you want to backup to the same file? And if you do that practice, are you going to append or replace? If is the last, eventually you could run into a situation of not having a backup at all!quote:
Originally posted by anitha2324
Hi all, any one help me to make schedule for taking the back up for the databse in sqlserver 2000 ( daily backup on specified time like 12 midnight every day and it should be in the same file )
J.C. AlexandresIT Professional |
|
|
|
anitha2324
Starting Member
18 Posts |
Posted - 2008-04-30 : 13:30:23
|
| Hi , thanks for the replys , I would like to append to the file not to replace |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-30 : 13:34:55
|
| Your file is going to get huge unless you have some process where you write to a new file every so often. Plus you are going to need a lot of disk space for this, depending on your database size.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
|
|
|
back up of the database