Viewing 15 posts - 12,451 through 12,465 (of 49,557 total)
A copy-only full backup does not reset the differential base. That's the only difference.
See - http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/
July 8, 2013 at 2:03 am
HanShi (7/8/2013)
mJai (7/7/2013)
I would like to have a backup of the SQL system databases (the files themselves) not the SQL backup.
Why would you want a copy of the files...
July 8, 2013 at 2:02 am
The SQL Server service account needs full permission on the folder. Go to the folder, the the security settings and give the account that SQL is running under full permissions.
July 7, 2013 at 2:13 pm
The in-built log shipping feature. As for docs, did you try Books Online?
July 7, 2013 at 4:57 am
S_Kumar_S (7/6/2013)
but log shipping will require my database of ServerB to be in restoring mode always, isn't it?
No. You can log ship to Standby mode, which allows you to...
July 6, 2013 at 3:21 pm
Check what wait type the shrink process has. It's a SQL Server process, it'll show in the DMVs like any other running session and a suspended status just means that...
July 6, 2013 at 2:23 pm
Jeff Moden (7/6/2013)
If there is no unique clustered index, then an 8 byte "uniquefier" is also added to the index.
Not quite
If there's no clustered index, the 8-byte RID is...
July 6, 2013 at 1:06 pm
Suspended means it's waiting for something. Check what the shrink is waiting for.
July 6, 2013 at 1:00 pm
Jeff Moden (7/6/2013)
July 6, 2013 at 9:52 am
That information is not stored anywhere. If you need that, you need triggers on the tables, a trace, CDC, change tracking or maybe SQL Audit, depending on exactly what you...
July 6, 2013 at 5:18 am
Maybe scroll down to the section "TempDB location does not exist", which describes how to fix exactly the problem you have?
July 5, 2013 at 5:37 pm
Steve Jones - SSC Editor (7/5/2013)
Hope everyone had a good Fourth.
One report written, one report half written, one client reducing his hours, one wanting urgent project yesterday. Average day.
July 5, 2013 at 1:13 pm
Steve Jones - SSC Editor (7/5/2013)
Tempdb being broken doesn't prevent the instance from starting.
Yes it does. If SQL cannot open and clear TempDB, the startup process will fail.
July 5, 2013 at 1:12 pm
Viewing 15 posts - 12,451 through 12,465 (of 49,557 total)