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
 Script Library
 Need Help, Script

Author  Topic 

Brandy
Starting Member

1 Post

Posted - 2007-04-20 : 09:57:40
Hello,

I run a simple backup on my BES Server to do a backup everyday. The commands I run are as follows:

C:\>osql -E
1> backup database besmgmt1 to disk = "c:\besdbapr19.bak"
2>go
Processed 3112 pages for database 'besmgmt1', file 'BESMgmt1_data' on file 1.
Processed 1 pages for database 'besmgmt1', file 'BESMgmt1_log' on file 1.
BACKUP DATABASE successfully processed 3113 pages in 3.222 seconds (7.913
MB/sec).

Is there a way to script this? I am fairly new to this so some handholding would be required Basically, the script should be smart enough to change file names as well.

Any help would be appreciated.

Thanks....

Kristen
Test

22859 Posts

Posted - 2007-04-20 : 09:59:40
Tara's Blog will probably give you a flying start:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Tara%20Blog%20Houskeeping%20Routines

Kristen
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-20 : 13:26:15
Here's a direct link to my database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

Check out isp_Backup.


Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -