drop / create new database with old name

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
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@.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
|||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@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:0b7f01c51837$db2c5230$a401280a@.phx.gbl...
dropped
>
>.
>

drop / create new database with old name

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,
DianaThat 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@.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|||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@.discussions.microsoft.com> wrote in
message
>news:0b7f01c51837$db2c5230$a401280a@.phx.gbl...
dropped[vbcol=seagreen]
>
>.
>

drop / create new database with old name

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,
DianaThe 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
>.
>|||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@.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|||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@.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
>
>.
>