Viewing 15 posts - 61 through 75 (of 180 total)
I think you should publish this question in the other branch - https://www.sqlservercentral.com/Forums/SQL-Server-2017/SQL-Server-2017-Administration
February 21, 2018 at 3:48 pm
February 21, 2018 at 1:53 pm
Is it a tape backup device or something else?
February 21, 2018 at 1:49 pm
Alternative options you can use are database audit or temporal tables.
https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine
https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables
February 20, 2018 at 6:49 pm
There are nothing against that. But in general I wouldn't recommend such configuration. Why don't you migrate 2014 databases on 2016?
February 19, 2018 at 4:12 pm
SQL Server 2017 on Linux does not have a listener.
February 15, 2018 at 1:00 pm
Hi,
There is another option - use AOAG on top of VMWare boxes.
February 14, 2018 at 7:57 pm
You can use NTILE to split rows between batches, more details here - https://docs.microsoft.com/en-us/sql/t-sql/functions/ntile-transact-sql
February 14, 2018 at 6:37 pm
Check that this backup file is valid:RESTORE VERIFYONLY FROM DISK = N'\\1.2.3.4\BackUp\Backup\Test.bak'
If it is not when backup your database in another file or use FORMAT option...
February 13, 2018 at 5:05 pm
Hi,
That is only option in this case. You can use msforeachdb in order to make it simple. Or you can write your own script.
February 12, 2018 at 8:07 pm
Unfortunately that is not officially supported by Microsoft - https://technet.microsoft.com/en-us/library/ms187348(v=sql.110).aspx
<update_stats_stream_option>
Identified for...
February 11, 2018 at 1:45 pm
Have you tried this method? https://blog.sqlauthority.com/2011/01/05/sql-server-copy-statistics-from-one-server-to-another-server/
February 11, 2018 at 1:41 pm
ALIF-662928 - Thursday, February 1, 2018 12:42 PM...20 TB in 2 files, got lot of unused space...
SQL Server backups do not store...
February 7, 2018 at 1:04 pm
Check that you can connect from the user/application pc using an odbc connection. If that is possible trace the SQL Server instance and make sure that Access is actually trying...
February 6, 2018 at 1:34 pm
I think that is easier on the application side. Also you may consider using encryption for sensitive data instead of RLS. https://docs.microsoft.com/en-us/sql/t-sql/functions/decryptbykey-transact-sql
February 1, 2018 at 3:29 pm
Viewing 15 posts - 61 through 75 (of 180 total)