December 1, 2011 at 1:45 pm
Hi All
Need help.
How can I backup all objects in database in SQL server 2005 without data?
I can use task generate script but I need to run it automatically every day.
Database has special requirement to do some weird thing like this.
I read about scriptio, but I can not install any third party program on the server.
I am not familiar with Powershell Script.
Anyone has script by TSQL? or can guide me?
Thank you in advance.
December 2, 2011 at 3:10 am
Powershell is the answer:
You don't need to be familiar with it, you just need to run it 🙂
-- Gianluca Sartori
December 2, 2011 at 4:47 am
Second vote for PowerShell. I'm pretty sure Allen White has a script over here somewhere.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 6, 2011 at 6:43 am
Thank you so much.
I really appreciated all your help.
James Jarupan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply