Viewing 8 posts - 61 through 68 (of 68 total)
Are you talking about preventing normal users access to viewing the table structure (columns etc.)?
September 25, 2008 at 9:31 am
Load Management Studio
Expand Databases
Right-click on your database
Choose Reports, Standard Reports, Disk Usage
Check out how much "unallocated" space (as a %) is in the file. Until this is basically zero...
September 24, 2008 at 3:36 am
With the ratio of data to log file size I'm going to guess your database is in full mode and you haven't been backing the log up. This causes...
September 22, 2008 at 5:49 am
Full Safety ON (from the mirror with the database being master)
ALTER DATABASE SET PARTNER OFF
RESTORE DATABASE WITH RECOVERY
Full Safety OFF (I think)
ALTER DATABASE SET...
September 19, 2008 at 7:24 am
A very simple way to check your logshipping is working is to make a small change in one table on the primary and see if it appears on the secondary...
September 18, 2008 at 9:48 am
They're all set to use the same schedule (of every 10 mins) . I'm guessing the job claims to have failed
July 6, 2007 at 8:36 am
According to the monitoring server, the latest file copied and restored was 14:40
BUT
Going to the physical C drive location of the secondary where it's dumping all these trans files from the...
July 6, 2007 at 7:45 am
Changes made to the live db are being reflected in the copied db in roughly the timeframe we'd expect so yes I'm fairly sure the log shipping is working. Plus...
July 5, 2007 at 8:41 am
Viewing 8 posts - 61 through 68 (of 68 total)