Viewing 15 posts - 3,196 through 3,210 (of 4,477 total)
To setup log shipping , why do u need to take a backup yourself...
August 17, 2017 at 9:40 am
August 17, 2017 at 9:24 am
Just a question regarding backups - for a smaller SQL database < 10 gb......
August 16, 2017 at 3:14 pm
IF (SELECT dbo.udf_TransactionExists()) = 1August 16, 2017 at 11:45 am
I'm creating a procedure to validate a database backup file and...
August 16, 2017 at 10:52 am
To set this up, try something like the following:
EXEC master . dbo. sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1
GO
EXEC master ....
August 16, 2017 at 8:37 am
I'm simply attempting to open an SQL Server table from an application that I...
August 16, 2017 at 8:25 am
I think it ends up being more of an issue of whether it's supported or not.
As Durai mentions, there are limitations on the mix of...
August 16, 2017 at 8:11 am
tazzman - Wednesday, August 16, 2017 4:17 AMYou can also collect values directly from windows performance monitor: https://www.red-gate.com/simple-talk/sql/performance/collecting-performance-data-into-a-sql-server-table/
It could probably be used...
August 16, 2017 at 7:55 am
Just to clarify in terms of bringing it up with the business, you really want to do that more as a CYA. When we are having to...
August 16, 2017 at 7:29 am
SELECT MAX(login_time) AS [Last...
August 16, 2017 at 7:20 am
When a sqlserver authenticated login is set to check_expiration=on, when will the user have to...
August 15, 2017 at 5:32 pm
August 15, 2017 at 2:00 pm
The backup usually is smaller as it won't be backing up unallocated space. Backup compression that Chris already mentioned can also result in the backup being much...
August 15, 2017 at 12:30 pm
You can use STANDBY mode if you want the secondary for log shipping to be read only. Or you can use NORECOVERY and the database stays in...
August 15, 2017 at 12:15 pm
Viewing 15 posts - 3,196 through 3,210 (of 4,477 total)