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 |
|
joliver
Starting Member
13 Posts |
 Posted - 2003-11-24 : 16:31:20
|
| Does anyone know if it's possible to backup a database, table definitions, stored procedures, UDF's etc etc (but no actual data) of all of the databases on a server on a regular basis (daily)? I don't particularly care if this is in the form of a SQL script that could be run to re-generate the database, or a binary file that could be restored or re-attached to the database.I'm already running a script that I found on this site to automatically backup all of the databases and data, (including automatically including newly created ones), but these files are starting to prove too large for our offsite backup service. |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
Schema backups?