Unix Technical Forum

emptying database

This is a discussion on emptying database within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi friend ! is there anyway to erase the whole content of a database other than executing the script....


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-01-2008, 03:43 PM
Phung
 
Posts: n/a
Default emptying database

Hi friend ! is there anyway to erase the whole content of a database
other than executing the script.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-01-2008, 03:43 PM
Greg D. Moore \(Strider\)
 
Posts: n/a
Default Re: emptying database

"Phung" <purwa@purwadhika.com> wrote in message
news:1193056060.280220.235250@e9g2000prf.googlegro ups.com...
> Hi friend ! is there anyway to erase the whole content of a database
> other than executing the script.
>


You could drop and recreate the DB.



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 03-01-2008, 03:43 PM
Jack Vamvas
 
Posts: n/a
Default Re: emptying database

If you are dropping and recreating , don't forget to take a script backup of
the db

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com




"Phung" <purwa@purwadhika.com> wrote in message
news:1193056060.280220.235250@e9g2000prf.googlegro ups.com...
> Hi friend ! is there anyway to erase the whole content of a database
> other than executing the script.
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:50 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com