Viewing 15 posts - 12,451 through 12,465 (of 49,552 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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2013 at 2:13 pm
The in-built log shipping feature. As for docs, did you try Books Online?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2013 at 1:06 pm
Suspended means it's waiting for something. Check what the shrink is waiting for.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2013 at 1:00 pm
Jeff Moden (7/6/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 5, 2013 at 5:37 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 5, 2013 at 4:30 pm
Did you read the article I referenced?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 5, 2013 at 4:28 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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 5, 2013 at 1:12 pm
Viewing 15 posts - 12,451 through 12,465 (of 49,552 total)