Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring database question

Author  Topic 

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-11-22 : 18:16:04
Hi,
I have 1 production and 1 development server.
I created few tables and stored procedure.
If i restrore database from production to Development server,

Please tell me, What will happen to tables and stored procedure created in development server that dont exist in production server.

It will stay there or it will be deleted.

Thanks
Manoj




mk_garg

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-11-22 : 18:17:05
They will be deleted. Restoring means creating a new one or overwriting the existing one.

Tara
Go to Top of Page

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-11-22 : 18:23:09
Thanks Tara.

mk_garg
Go to Top of Page
   

- Advertisement -