SQL Server Performance Forum – Threads Archive

SQL Development server Backups

I need to backup all dbs on my sql development server. Yet I don’t care for the data I just need the structure / store procedures / views etc… Is there a better option than just backing up the whole along with the large amounts of data

Yes, you can create a script (using EM) with all except data.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks for the prompt response. But is there a way to automate the script generation? I have about 25 Dbs and doing it each time manually is not an option.

Well, in that case the only way I know is using 3rd part tools.
See ours sponsors to find adequate to you.
That kind of tools also can check differences from databases, in that way you only have to backup changes.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>