Thanks for pointing out GDPR and HIPAA, need to check that too

Thank for your input.
I have quick question if we implement TDE in sql server 2014 for Database at Rest, During Refresh from PRODUCTION to TEST, what happened?
How to...

Thank you, It was really great help!

Thanks Gail.
Yes, you are right only once i need to do step 2.
I don't want the login from production as i have to keep TEST login as it's...

Thanks Jeffrey for details explanation.

Please correct me if i am following steps and you think something not going to work.

January 13, 2019 at 10:52 am

#2018791

Thanks but we can't keep the same SID as production is not the same access.
After i restore multiple DB, i have to run the script to remove orphan users...

Thanks for that but i know it as restoring backup will do it as it's normal way we restore the db but we have few databases and lots of users...

Thanks.
I need just number, data and varchar type but it will be ok any kind of data as i am testing connectivity.

Actually I need to Createa simple CSV and upload it to sql server and OR other application.

Your help really Appreciated it!

Thanks.

I got it, Thanks.

;WIth mycte as (SELECT

s.database_name,

s.[type]

,row_number() Over(Partition by s.[type] Order by s.backup_finish_date DESC ) RN

FROM msdb.dbo.backupset s

INNER JOIN msdb.dbo.backupmediafamily m ON s.media_set_id = m.media_set_id)

Select database_name, max(case...

Thank for your help!

Thanks, you mean it will be better if I start with 100 MB and 10 MB auto growth?

Thanks.

I mean to say "not clearing space" means even though after restarting the server, it's still shows close to 5 GB.

Do you think that if I change Initial size to...