Viewing 15 posts - 30,511 through 30,525 (of 49,552 total)
It is trivial to prove that full backups do not break the log chain. Thusly: (you'll have to change the backup destination to fit what you have)
CREATE DATABASE TestingLogRestore
GO
ALTER DATABASE...
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
September 20, 2010 at 3:02 pm
SQL_Quest-825434 (9/20/2010)
Instead use COPY_ONLY...
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
September 20, 2010 at 2:52 pm
No. In most cases system stored procedures are not stored in user databases. They're all stored in a hidden database called the system resource database. So procedures like sp_help, sp_who,...
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
September 20, 2010 at 1:39 pm
As I said...
GilaMonster (9/20/2010)
System stored procs generally aren't stored in the user databases, they're in the hidden system resource database.
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
September 20, 2010 at 1:30 pm
1) 4GB
2) Not sure, don't think there's a limit.
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
September 20, 2010 at 1:20 pm
System stored procs generally aren't stored in the user databases, they're in the hidden system resource database.
Try this
SELECT *
FROM sys.system_objects
WHERE type = 'P'
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
September 20, 2010 at 1:19 pm
josh_boudinot (9/20/2010)
set the date column to not null, then it will use the default if you don't supply any data for that column
Defaults will be used regardless of whether the...
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
September 20, 2010 at 1:13 pm
Full backups do not truncate the transaction log. They do not break log shipping.
Look at what else is happening at the time of the full backup. A switch 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
September 20, 2010 at 1:05 pm
Thanks to everyone for the congrats. Lotsa work and time into that count.
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
September 20, 2010 at 11:55 am
Brandie Tarvin (9/20/2010)
Jeff Moden (9/20/2010)
GilaMonster (9/20/2010)
*trumpet crescendo*
... and I think I'll leave things here for a little while.
Edit: And as soon as i decide not to post for a...
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
September 20, 2010 at 11:54 am
Jeff
Would you like a run on 2008 R2? Will have to be this weekend at earliest, cause I'm not planning to upgrade before then.
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
September 20, 2010 at 11:39 am
sivaj2k (9/20/2010)
Hiif Database wants to insert the current date, you have to create trigger on that table.
That's true for updates and updated date, but not for inserts.
See revised example:
create table...
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
September 20, 2010 at 11:26 am
Back to posting. Couldn't stand seeing someone mangle the corruption question any longer...
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
September 20, 2010 at 9:43 am
SKYBVI (9/20/2010)
That means microsoft just repeats its questions??
Yup. With the thousands of people who write the exams do you honestly think that they could generate new questions for each one?
They...
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
September 20, 2010 at 9:34 am
SKYBVI (9/20/2010)
Where do you study from, for the MCITP exams..
Books Online and exam guide books (yes, I buy them sometimes)
Cant u study from dumps??
There should be some practice questions also...
Dumps...
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
September 20, 2010 at 9:24 am
Viewing 15 posts - 30,511 through 30,525 (of 49,552 total)