Need script advice | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Need script advice

What I am trying to accomplish would be to have a job that ran every week or so that scripted out 4 databases on one of our cluster instances. I don’t need the data, just the table structure, indexes, stored procs, etc… The reason being, it is our data repository for ad hoc queries and the like instead of folks querying DB2 and putting additional stress on the mainframe. I want the structure so that if we lost these lovely tables, I wouldn’t have to rebuild them all one at a time, I could just run the script, viola, we have tables, then run the nightly jobs to populate them and we would be golden… We currently take one full backup weekly of these databases for the structure purposes only, and they are hovering at 400GB, I figure the script of the ddl would be a lot smaller… <img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ /><br /><br />I can do this one at a time through EM, but I would rather have a job that did this for me every weekend so that I wouldn’t have to remember to do it myself.<br /><br />Any ideas, or path’s to send me down?<br /><br />TIA
Check my webloghttp://www.sql-server-performance.com/absolutenm/templates/?a=9&z=1 in this regard. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Ok, I cannot find the upgrade directory in any installation of SQLServer that I can find? We are running MSSQL2000 SP3 on WIN 2003? That looks EXACTLY what I want to do.
Try searching for scptxfr.exe in your machine or take further help fromhttp://www.databasejournal.com/features/mssql/article.php/3401081 here. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>