Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restoring Database to a different Database Name

Status
Not open for further replies.
RemingtonSteel

RemingtonSteel

Programmer
Jul 14, 2006
65
GB
Hello!

I have DatabaseA. I have made a backup of it (DatabaseA).
I also have DatabaseB (empty but exact the same struture with DatabaseA). Can I restore DatabaseA into DatabaseB?
What are the pitfalls if I do this.

Thanks!
Gene
 
Sort by date Sort by votes
Yes, it should work without a problem, AFAIK. Just choose override option when you would be doing restore.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
154
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
330
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
389
gmmastros
gmmastros
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
504
Chris Miller
Chris Miller
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
447
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top