Avatar of CipherIS
CipherIS
Flag for United States of America asked on

SQL Server - Copy database from one server to another

Is there a way to copy a database from one server to another without performing a backup?  

I want test to copy a database in the production server.
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment
Stuart Dryden

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Tom Cieslik

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
CipherIS

ASKER
Thanks.  I did backup the database.  Can't stop the services.  So, guess I will need to log onto the server and copy the file to the test server.

Thanks.
Stuart Dryden

There is an AWSOME powershell module for exactly this.  it makes it easy any convenient beyond belief - including in an Aure environment if that is what you need.  Check out the powershell gallery and search for 'DBATOOLS'

i promise you will be impressed!

or directly to their website.  its a free module !

edit***

never mind, dont go there, the module is rubbish and expensive !!

why do people on here always close the question and score the first half helpful answer?

maybe other people have ideas too that can contribute ?

https://dbatools.io/
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck