SQL Server - Is there a way to backup backup jobs?

Simple question, Is there a way to backup backup jobs?  I only want to
do this becuase I have a job that runs a series of TSQL statements
that are rather lengthy.

  mike11d11 replied...

I'm retarded, I'm mean to just backup scheduled jobs that i have and
not backup jobs.  I have a backup of my database, but when i restore
it, it does not restore my jobs.  I need to figure out how to do this
if at all possible.

  Jay replied...

Look in BOL for: "sp_help_job" and go from there.

  Jeffrey Williams replied...

SQL Agent Jobs are stored in the MSDB database.  Make sure you have a
maintenance plan that backs up this database and you can restore the
database with all jobs.

Another option would be to script out the jobs and save the scripts in
your source control system.

Jeff

Server Management Studio I open the Connect to Server box with these values: Server Type: "Database Engine"; Server name: "ICHIBAN \ SQLEXPRESS" which is the correct name for the computer and the No user action is required. 2008-12-27 11:28:20.90 spid7s Starting up database 'master'. 2008-12-27 11:28:21.09 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 00000003 2008 was started by login "sa". 2008-12-27 11:28:21.24 spid7s Starting up database 'mssqlsystemresource'. 2008-12-27 11:28:21.28 spid7s The resource database build version is 10. 00.1600. This is an informational message only. No user action is required. 2008-12-27 11:28:21.57 spid15s Starting up database 'model'. 2008-12-27 11:28:21.57 spid7s Server name is 'ICHIBAN \ SQLEXPRESS'. This functionality will not be available. 2008-12-27 11:28:21.81 spid7s Starting up database 'msdb'. 2008-12-27 11:28:21.87 spid15s Clearing tempdb database. 2008-12-27 11:28:22.23 Server A self-generated certificate was successfully loaded

with domain / administrator. SQL Server Discussions SQL Server 2000 (1) Stored procedure (1) Errorlog (1) Backup (1) Class (1) Lock (1) Date (1) FleetAdminDB (1) here is errorlog 2007-11-15 to initialize Distributed Transaction Coordinator. 2007-11-15 03:13:24.89 spid4 Starting up database 'master'. 2007-11-15 03:13:26.89 server Using 'SSNETLIB.DLL' version '8.0.2039'. 2007-11-15 03:13:26.89 spid5 Starting up database 'model'. 2007-11-15 03:13:27.06 spid4 Server name is 'BUSSERVER'. 2007-11 15 03:13:27.10 spid8 Starting up database 'msdb'. 2007-11-15 03:13:27.23 spid9 Starting up database 'pubs'. 2007-11-15 03:13:27.23 spid10 Starting up database 'Northwind'. 2007-11-15 03:13:27.23 spid11 Starting up database 'BUS'. 2007-11-15 03:13:27.40 spid12 Starting up database 'LogDB_Main'. 2007-11-15 03:13:27.53 spid13 Starting up database 'POI_Polet'. 2007-11

Requesting Backup / Restore Theory Explanation SQL Server MSSQL backups are odd in that the data and transaction logs are two different backup operations it seems. Normally, when a backup is performed, the data and log file can be archived at exactly the same time as the archived one except there are no transactions in the transaction log. If a database must be restored, the transaction file in the live area or its mirror is exported to an SQL file, and the previous backup data and transaction file is moved to the live area, and the SQL file is run against the restored database resulting in zero potential for data loss. The SQL file can even be edited prior more clumsy? I'm trying to put together some TSQL for MSSQL 2008 Express for backup, restore to last backup, and restore from failure using a roll-forward from last backup. There is no clear

transaction log backup fails on sql server 2005 SQL Server hello guys, I have a database on a sql server 2005. A maintenance plan performs a full backup every night, while a backup of the transaction log is done every 15 minutes. last night all log backup failed from the early morning onwards. the error is "BACKUP LOG cannot be performed because there is no current database backup". the database is in full recovery mode. any help ? I don't quiete know why

Database needs to be in single user mode to be backed up by DBMain SQL Server are failing. It appears that databases needs to be in single user mode for the backup to occurr. Not sure how to go about this though. Is my Symantec Backup Exec causing this problem? Nobody is using the database in the middle of the night, when the DB Maintenance Plan kicks in to back Starting maintenance plan 'DB Maintenance Plan99' on 11 / 14 / 2008 3:00:00 AM [1] Database ECSTORE: Check Data and Index Linkage. . . * * Execution Time: 0 hrs, 0 mins, 1 secs * * [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL Server Driver][SQL Server]Database state cannot be changed while other users are using the database 'FRESQL' [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement failed. [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed. [2] Database FRESQL