Viewing 15 posts - 106 through 120 (of 260 total)
Setup a firewall rule to block SQL port from other IP addresses(this will potentially block all the login attempts from out side, not just for 'sa' login) or may be...
May 16, 2018 at 3:42 pm
Are they Intermittent? Do you see any HADR Backup locks? If yes, refer this: https://support.microsoft.com/en-us/help/3171896
May 16, 2018 at 12:35 pm
Assuming you are referring to 'Is_master_key_Encrypted_by_server" column in sys.databases, you missed nothing. That column will not be set in sys.databases for all TDE enabled databases. The DMK which is used...
May 14, 2018 at 12:45 pm
Hello Kaplan,
Pretty much every SQL monitoring tool/application can be set to send alerts for missing database backups. A simple powershell script or an SSIS package can be used...
May 9, 2018 at 11:54 am
May 2, 2018 at 10:32 am
Then...
May 2, 2018 at 8:31 am
You should be able to apply filters based on Database_id once you get to that part. Refer to this article for detailed info...
https://www.mssqltips.com/sqlservertip/5176/overview-of-xevent-profiler-in-sql-server-management-studio/
Hope this helps.
February 26, 2018 at 1:39 pm
You could just use Import Export wizard from SSMS(SQL Server Management Studio) to dump data from Excel file to SQL Server table. I would stay away from creating Linked servers...
February 26, 2018 at 1:32 pm
Taking Adhoc full backups pointing to S3 Shouldn't break anything in log shipping setup.
Being said that, I would recommend testing this in your Dev region for you to be...
February 15, 2018 at 11:56 am
I haven't implemented this personally, but found this github repository when I Binged for your question. Hope this helps you or at least directs you in the correct direction.
February 12, 2018 at 7:51 am
Alexandres,
What does the setup log(s) say? BTW, did you try SlipStream setup?
February 5, 2018 at 9:59 am
An AG is a single unit for failover. So....Entire AG(All the underlying DBs) will be moved over to another replica based on your setup, You can't have a single DB...
February 5, 2018 at 9:46 am
Sounds like just SSMS thing. Curios, Are you attempting to setup using SSMS 2012 or SSMS 2008? Have you tried adding your subscriber using T-SQL script?
January 31, 2018 at 12:08 pm
Did you restarted Agent Service after making that change under your SQL Agent properties?
January 11, 2018 at 10:01 am
You can start with this...
https://bradmcgehee.com/2010/03/30/an-introduction-to-sql-server-2008-audit/
January 10, 2018 at 11:50 am
Viewing 15 posts - 106 through 120 (of 260 total)