Viewing 15 posts - 181 through 195 (of 1,162 total)
Could you post actual execution plans (not estimated) and DDL (including indexes), please?
June 12, 2013 at 10:46 am
It sounds like the Red-Gate backup was created with multiple threads (therefore multiple files for the same backup).
Just need to list them all in the restore syntax:
RESTORE VERIFYONLY
FROM DISK =...
June 12, 2013 at 10:33 am
Look in task manager, under processes and find the ReportingServicesService.exe process.
June 12, 2013 at 2:19 am
Not in the same way as Oracle, as in a pre-packaged set of configurations, permissions and audit rules, but it has all the constituent parts in order to configure this....
June 11, 2013 at 12:00 pm
Do you mean Database Vault rather than Data Guard? Data Guard is an HA/DR technology.
June 11, 2013 at 11:32 am
Windows Server Failover Clustering and SQL Server Failover Clustering are separate technologies. The former is the clustering of the Operating System and the latter is of SQL Server instances (which...
June 11, 2013 at 9:53 am
Matthew Darwin (6/11/2013)
As for shrinking the files, you can run a DBCC SHRINKFILE command against tempdb
I'd be cautious about this. I think the official recommendation is still to only do...
June 11, 2013 at 8:06 am
barry.mcconnell (6/11/2013)
You could also use IIF such asselect iif(a<b,1,0) as test
This was posted in the 2008 forum, so I'm assuming that 2012-only features aren't applicable.
June 11, 2013 at 6:54 am
If there are no dependencies on the table and you're deleting a large portion of it, you'll find it a lot less expensive to create a new table with the...
June 11, 2013 at 6:29 am
Mirroring or AlwaysOn would be the equivalent of Data Guard in SQL Server, although it has some fundamental differences (e.g. it's at the level of an individual database, rather than...
June 11, 2013 at 2:20 am
Err...you close off your SQL Server from the outside world at the network level.
It's dangerous to have your SQL Server instance exposed to the internet without any inbound IP restrictions,...
June 10, 2013 at 9:03 am
If it's a one-off export, try exporting to a csv file instead, then you can re-save as an Excel if required. You're pretty close to the limits of an excel...
June 10, 2013 at 7:51 am
That's not the error, it's a warning. That's a warning that's very common and usually not the cause of any real problem.
The errors are the exclamation mark symbols further down...
June 10, 2013 at 7:35 am
Easy enough to find the size of the backup files, assuming msdb still has the history:
SELECT backup_finish_date, backup_size/1024.0/1024.0 AS Backup_Size_MB FROM msdb..backupset
WHERE type='L'
AND backup_finish_date BETWEEN 'datetime1' AND 'datetime2'
Seems a pretty...
June 10, 2013 at 4:42 am
Start SQL Server in minimal configuration mode from the command line (-f flag). This will create tempdb in the default location and allow you to run an ALTER command.
You might...
June 10, 2013 at 4:03 am
Viewing 15 posts - 181 through 195 (of 1,162 total)