last day (15 days later) » 

Stack Exchange
Stack Exchange
20:57
0
A: Creating a copy of primary database and attaching the copy database in the same sql instance

KinIF the server is NOT a PRODUCTION server, then you can backup the databases you need for Data manipulation and restore them with databaseName_test. Keep in mind that you will still be competing for resources on the server by creating another set of databases. Why cant you install another instan...

goofyui
goofyui
Server is a Production Server. Just now i noticed, we have express edition. All database are less than 5 GB
Kin
Kin
backup restore is the way to go. I have rarely seen Production server running sql express.
goofyui
goofyui
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Business Intelligence Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
i got the result from select version sql command
Kin
Kin
You should better know what you are working on.. as you said it is express edition and now it has changed !
goofyui
goofyui
Kin, Thank you. I have posted the query result in the Posting
Kin
Kin
20:57
@goofyui I still dont understand what you want ? I have answered your question. Do you have anything that you want me to clarify ?
goofyui
goofyui
Hello Kin, Can i have copy of original database in the same sql instance( Production Server ). This is my original question. I am looking answer for that question.
Kin
Kin
Yes .. you can, as I mentioned restore it as a different name e.g. database_test or database_temp
goofyui
goofyui
@Kin in you answer
Ooh great. Thank you
You solved my problem.
Kin
Kin
Normally, I avoid to create temp databases on prod .. as its not a good practice .
but it depends on what you will be doing ... as running workload or queries will/can impact PROD
goofyui
goofyui
I had an issue in the past around 2009. I was running a copy of the original database in the same instance. Although copy database had a different name. It was mistakenly mapped to original database .mdf / .ldf. So it was not a copy. Anyways, i will avoid such situations
I agree with you to avoid the Production Server. I think for time being, i will go with Production Server.

last day (15 days later) »