Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

drop / create new database with old name

  
   Database Help (Home) -> Server RSS
Next:  IIS anonymous and SQL (possible hacking?)  
Author Message
DianaR

External


Since: Feb 21, 2005
Posts: 1



(Msg. 1) Posted: Mon Feb 21, 2005 10:07 am
Post subject: drop / create new database with old name
Archived from groups: microsoft>public>sqlserver>server (more info?)
Hi,
Is it possible to drop and then create a new, fresh
database with the same name as the database just dropped
or would this cause problems? I don't want to recreate
this database from backups as there are concerns.
Thanks,
Diana

 >> Stay informed about: drop / create new database with old name 
Back to top
Login to vote
Peter The Spate

External


Since: Feb 09, 2005
Posts: 21



(Msg. 2) Posted: Mon Feb 21, 2005 10:29 am
Post subject: drop / create new database with old name [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
The only problem I can think of is to do with the table
sysdatabases in the master database.

If you refer to the database by its dbid anywhere then
there is a good chance it might change when you re-create
it.

Peter

"The best minds are not in government. If any were,
business would steal them away."
Ronald Reagan


 >-----Original Message-----
 >Hi,
 >Is it possible to drop and then create a new, fresh
 >database with the same name as the database just dropped
 >or would this cause problems? I don't want to recreate
 >this database from backups as there are concerns.
 >Thanks,
 >Diana
 >.
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: drop / create new database with old name 
Back to top
Login to vote
Adam Machanic1

External


Since: May 25, 2004
Posts: 67



(Msg. 3) Posted: Mon Feb 21, 2005 1:40 pm
Post subject: Re: drop / create new database with old name [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
That should cause no problems... is there some reason you would expect it
to?


--
Adam Machanic
SQL Server MVP
<a style='text-decoration: underline;' href="http://www.sqljunkies.com/weblog/amachanic" target="_blank">http://www.sqljunkies.com/weblog/amachanic</a>
--


"DianaR" <anonymous DeleteThis @discussions.microsoft.com> wrote in message
news:0b7f01c51837$db2c5230$a401280a@phx.gbl...
 > Hi,
 > Is it possible to drop and then create a new, fresh
 > database with the same name as the database just dropped
 > or would this cause problems? I don't want to recreate
 > this database from backups as there are concerns.
 > Thanks,
 > Diana<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: drop / create new database with old name 
Back to top
Login to vote
anonymous1

External


Since: Oct 22, 2003
Posts: 589



(Msg. 4) Posted: Mon Feb 21, 2005 2:00 pm
Post subject: Re: drop / create new database with old name [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Adam,
No, no reason... just wanted to make sure.
Thanks for your reply.
Diana

 >-----Original Message-----
 >That should cause no problems... is there some reason
you would expect it
 >to?
 >
 >
 >--
 >Adam Machanic
 >SQL Server MVP
 >http://www.sqljunkies.com/weblog/amachanic
 >--
 >
 >
 >"DianaR" <anonymous DeleteThis @discussions.microsoft.com> wrote in
message
 >news:0b7f01c51837$db2c5230$a401280a@phx.gbl...
  >> Hi,
  >> Is it possible to drop and then create a new, fresh
  >> database with the same name as the database just
dropped
  >> or would this cause problems? I don't want to recreate
  >> this database from backups as there are concerns.
  >> Thanks,
  >> Diana
 >
 >
 >.
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: drop / create new database with old name 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
simple question drop database - I want to start over because I fixed some keys and fields. The first create database was a test. So I wonder how to drop the database. I have the drop database template. My database tables were created in "master" which I assume is a system...

Create database fails - HI All, Environment: Windows2003, SQL : Microsoft SQL Server 2000 - 8.00.818 (sp3+hotfix) When I execute below simple create database command without specifying the file name, i got below error. If i explicitly specify the file ( just mdf file),....

Scripting with Create Database - I'm preparing an install package for my app with an accompanying SQLExpress database. A couple of questions ... Using "Script Database > Create to" from the SSM Studio, I noticed the script assigns the file location as the current file lo...

Create "TEST" copy of replicated database - I attempted to restore a database from a backup of a production database that is being replicated. I changed the database name with a prefix of "TEST" and verified that the files being restored had the same "TEST" prefix. I also ...

Create View with schemabinding from other database table - Hello, I am trying to create index view fore that I went to create view with schemabinding . If I try table in same database it work properly. But my database is different from I went to create view. syntax is this CREATE VIEW VSTATE WITH..
   Database Help (Home) -> Server All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]