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 |
|
rohit_sql
Starting Member
2 Posts |
 Posted - 2007-08-30 : 09:39:47
|
| How to take timely(say, for every week)backup of my database dynamically. I tried using "maintenance plans" option to do this...but didn't succeeded.I this the option for my requirement. If so, could any one please explain me how to do this.And there is any other option, please explain me that too.thanks in advanceregardsrohit |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-30 : 09:50:46
|
"say, for every week"I would prefer that you "say" daily FULL backup and Log backup every 10 minutes  "I tried using "maintenance plans" option to do this...but didn't succeeded"I reckon this is your best place to start. What error/problem did you have?Kristen |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 00:27:48
|
| What do you mean backup db dynamically by the way? |
|
|
|
rohit_sql
Starting Member
2 Posts |
Posted - 2007-08-31 : 05:13:57
|
| hi kristenthanks for your reply.I tried giving the extension for the backup as mdf, sql, bak.but no backup file is being created...and i'm not receiving any mail(i selected that option too)could you please explain me the complete process of taking backup.regardsrohit |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 16:07:08
|
| Did you see maintenance jobs under jobs in em? Is sql agent running? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-04 : 15:38:43
|
| 1. create a backup script, put it inside a stored procedure2. run the stored procedure in a job and schedule the jobkristen, kristen, kristen = test, test, test--------------------keeping it simple... |
|
|
|
|
|
|
How to take backup of sqlserver db dynamically