Member Avatar for nadineatwaroo

Hey All,

I wanted to find if it this is possible. I have a db in sql server with some large tables and I would like to transfer the entire db from one server to another server without having to create the tables and so on. Is this possible?

Thanks

  • 2 Contributors
  • 1 Reply
  • 85 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by Fest3er
Member Avatar for Fest3er

...I have a db in sql server with some large tables and I would like to transfer the entire db from one server to another server without having to create the tables and so on. Is this possible?

It would seem to be possible. Use the BACKUP command to make the dump. Use the RESTORE command to restore it.

And from Experts Xchange:

restore database dev
from disk = 'c:\temp\james\dev.bak'
with move 'dev' to 'c:\dev_data.mdf',
move 'dev_log' to 'c:\dev_log.ldf'

Agoogle search for "sql server dump" will yield much arcane info on this.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.