Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
Afternoon All,
I have a client, they have 1 SQL server and on it they have 2 Instances of SQL 2012
One is a fully licensed version they own, the other is an expired trial 
I have managed to get into the SQL Manager on the server and wondered if there is a fast'ish way to simply move the data and security settings from one instance to the other.
Or am I best using the backup and restore method and scripting the security settings over ?
I've tried to use the "Copy" option however it just seems to crash out on the final export.
Any ideas ?
|
VrsTurbo
Premium Member
Registered: 8th Jun 10
User status: Offline
|
Backup and restore. always!
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
quote:
Originally posted by VrsTurbo
Backup and restore. always!
This.
Also, how big is the DB, is it likely to grow that much in the future?
IIRC, the latest version of SQL express gives you a free 10gb limit, so long as its not being constantly hammered, it ought to do the job.
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
I've just striped backing up and restoring databases in the past... But... Getting the software to look at the right instance can be harder!
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
There are about 9 or 10 different dbs running. One of the dbs is 9gb itself. Was hoping there may be a quicker way to do it.
I noticed I couldnt run a query to script the logins in 2012, how can you move these now ? I've not got the time to invest to much into this atm and hoped it'd be as easy as moving from 05 
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
Ill copy you what I'm using tomorrow mate.
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
I'm backing up databases using this syntax:
SqlCmd -E -S Server_Name\Instance_Name –Q “BACKUP DATABASE [Name_of_Database] TO DISK=’X athToBackupLocation[Name_of_Database].bak’”
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
Found out why my query was wrong so permissions moved nicely, got all the apps set up and couldn't work out why nothing could connect. I had forgotten to enable mixed authentication Tard
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
Often one bloody tickbox that causes all the problems!
|
