By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

How can i have a copy of entire databse with out data??

ganeshkumar08
P: 31
Hi all,

Using generate scripts i generated the database script file and executed,
i got an error.

How to copy the entire database without data.

Can any one help me..

Ganesh
Apr 21 '08 #1
Share this Question
Share on Google+
4 Replies


ck9663
Expert 2.5K+
P: 2,878
What error did you get?

-- CK
Apr 21 '08 #2

ganeshkumar08
P: 31
Its a SP error, which i did mistake..
Can u tell the procedure to generate script, i need to have script like this...
I should not even create a new database, the script should have create new database also..

Can u pls tell me...
Apr 22 '08 #3

ck9663
Expert 2.5K+
P: 2,878
Are you planning to copy a database? Or just create a new one?

Why not just create a new one? Try this

-- CK
Apr 22 '08 #4

ganeshkumar08
P: 31
I need all the Table, SP, View, Schema scripts.
So, using this scripts i want to execute in another server. My requirement is i need to generate a DB script file which should be executed in another server. So, while executing the script the database also must created with tables, SP, View, Schema etc..
Apr 25 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.