May
31
awarded  Popular Question
2018
Mar
19
accepted Restoring a database
Mar
18
comment Restoring a database
@AaronBertrand, can you please explain why? I asked local admin about this case and he said, that this happens because of a tail log. So the live database is changing its status because Dev database needs a data from Live that is not in the backup. I mean if I made a bak at 10 am and restoring it to Dev at 12am, live db is locked so this 2 hour data is also added to Dev.
Mar
16
asked Restoring a database
Mar
5
awarded  Popular Question
2016
Nov
21
awarded  Supporter
Nov
21
comment Synchronizing data from AWS Sql Server to local database
Hello @Shawn, so if I configure connections between AWS and local machine I will be able to do replications between instances on AWS and local? We have SQL Server Express editions on both. I sthere any walkthrough articles about this? If row is added to a table on AWS it shoud be replicated to local and vice versa.
Nov
21
asked Synchronizing data from AWS Sql Server to local database
May
20
awarded  Student
May
20
awarded  Peer Pressure
May
19
awarded  Commentator
May
17
comment Change database login default schema
Yes I can do this manually adding windows login and user with that loging. Then I can change the default schema of that user. It seems like I can not do this for admins.
May
17
comment Change database login default schema
As I guess I can not do this for admin login? I should add some other windows login and then add user based on that login to the database?
May
17
awarded  Editor
May
17
comment Change database login default schema
Yes it has as I said in the question. It is dbo. But how can I change that? I can not delete dbo user from database?!
May
17
revised Change database login default schema
added 138 characters in body
May
17
asked Change database login default schema
2015
Oct
19
comment Get the old version of stored procedure code in sql server
Restore it from the backup of the database.
Apr
16
awarded  Scholar
Apr
16
accepted Sql Server audit could not write to the security log