No Differential Backup on Master DB

Hi, Can someone plzz explain the below reason
"Differential backups are not allowed for the master database since
they require that complete backups be applied without recovery as the
first step. When restoring the master database, restore without
recovery is not allowed."
Hi
If you look in BOL on how Master DB needs to be restored, you will notice
that it is not an easy procedure.
If Master DB gets bigger than a manageable size (say 100Mb), then you have a
serious problem. You have user objects in there and you are compromising
your recoverability of your server.
A small DB like Master needs no differential backups and not much changes in
it, and it is so quick to do a full backup, that it is not worth the effort.
Regards-
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1131737977.922320.82800@.g14g2000cwa.googlegro ups.com...
> Hi, Can someone plzz explain the below reason
> "Differential backups are not allowed for the master database since
> they require that complete backups be applied without recovery as the
> first step. When restoring the master database, restore without
> recovery is not allowed."
>

No Differential Backup on Master DB

Hi, Can someone plzz explain the below reason
"Differential backups are not allowed for the master database since
they require that complete backups be applied without recovery as the
first step. When restoring the master database, restore without
recovery is not allowed."Hi
If you look in BOL on how Master DB needs to be restored, you will notice
that it is not an easy procedure.
If Master DB gets bigger than a manageable size (say 100Mb), then you have a
serious problem. You have user objects in there and you are compromising
your recoverability of your server.
A small DB like Master needs no differential backups and not much changes in
it, and it is so quick to do a full backup, that it is not worth the effort.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1131737977.922320.82800@.g14g2000cwa.googlegroups.com...
> Hi, Can someone plzz explain the below reason
> "Differential backups are not allowed for the master database since
> they require that complete backups be applied without recovery as the
> first step. When restoring the master database, restore without
> recovery is not allowed."
>sql

No Differential Backup on Master DB

Hi, Can someone plzz explain the below reason
"Differential backups are not allowed for the master database since
they require that complete backups be applied without recovery as the
first step. When restoring the master database, restore without
recovery is not allowed."Hi
If you look in BOL on how Master DB needs to be restored, you will notice
that it is not an easy procedure.
If Master DB gets bigger than a manageable size (say 100Mb), then you have a
serious problem. You have user objects in there and you are compromising
your recoverability of your server.
A small DB like Master needs no differential backups and not much changes in
it, and it is so quick to do a full backup, that it is not worth the effort.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1131737977.922320.82800@.g14g2000cwa.googlegroups.com...
> Hi, Can someone plzz explain the below reason
> "Differential backups are not allowed for the master database since
> they require that complete backups be applied without recovery as the
> first step. When restoring the master database, restore without
> recovery is not allowed."
>

Nile 2.0

http://www.microsoft.com/downloads/details.aspx?familyid=3Db34a83f1-8fd3-= 4a1e-a423-e2cb0c16c0a8&displaylang=3Den
Could someone explain where this application goes wrong and let me know = where to set it right. It does not work as written. The VBCOM+SQL = part. Thanks.
-- George Hester
__________________________________Hi George.
That's a very open question - could you perhaps define it a bit by
describing the actual problem you're experiencing?
Keep in mind that this is a SQL Server newsgroup & perhaps any VB/COM
aspects of your question may be better asked in their respective newsgroups.
Otherwise, seasons greetings!
Regards,
Greg Linwood
SQL Server MVP
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:%23V3HDGbyDHA.2620@.TK2MSFTNGP09.phx.gbl...
http://www.microsoft.com/downloads/details.aspx?familyid=b34a83f1-8fd3-4a1e-a423-e2cb0c16c0a8&displaylang=en
Could someone explain where this application goes wrong and let me know
where to set it right. It does not work as written. The VBCOM+SQL part.
Thanks.
--
George Hester
__________________________________|||Hi Greg thanks for responding. I wish I could tell you something that =went wrong. I can't. There were no errors of any kind. None. So I =assume from that all the SQL Server connections were correct. But I =have no products at all. I looked in the table in SQL and they are all =like Product1, Product2,... and so on. But in any case I get nothing =the login doesn't work (I can login by chossinng add a user and just hit =submit) at all and all in all it just doesn't work. Oh well I thought =maybe someone here may have tried this example in the past and could =tell me what they did to get it to work. If they said, "Well I followed =the directions" then actually that would be enough for me since I did =change the connection string to allow IUSR_MachineName to connect. But =since I am not getting any connection errors I assume the issue is not =there.
-- George Hester
__________________________________
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message =news:OEgMFnbyDHA.540@.tk2msftngp13.phx.gbl...
> Hi George.
> > That's a very open question - could you perhaps define it a bit by
> describing the actual problem you're experiencing?
> > Keep in mind that this is a SQL Server newsgroup & perhaps any VB/COM
> aspects of your question may be better asked in their respective =newsgroups.
> > Otherwise, seasons greetings!
> > Regards,
> Greg Linwood
> SQL Server MVP
> > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:%23V3HDGbyDHA.2620@.TK2MSFTNGP09.phx.gbl...
> =http://www.microsoft.com/downloads/details.aspx?familyid=3Db34a83f1-8fd3-=
4a1e-a423-e2cb0c16c0a8&displaylang=3Den
> > Could someone explain where this application goes wrong and let me =know
> where to set it right. It does not work as written. The VBCOM+SQL =part.
> Thanks.
> > -- > George Hester
> __________________________________
> >|||Hi George.
I feel for you brother! I've been through similar experiences with products
that you download, hoping that things will just work straight up & more
times than not, there's something that bites you in the ass.. I guess it at
least helps us appreciate when things work as they should.
One thing I'd suggest is to use SQL Profiler to peek into the background SQL
Server activity. That way you'll at least get the opportunity to see what's
going on (if anything) at the SQL level. Other options may be to attach the
Win32 debugger to the VB process or other debuggers such as VC++, softice
etc - these will give you some insight into the VB executable's activity.
COM+ has a few GUI features that let you view activity within it's runtime
as well.. Perhaps using these tools, you might be able to at least glean at
what component levels things are / aren't happening.
HTH
Regards,
Greg Linwood
SQL Server MVP
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:emCrfRcyDHA.2148@.TK2MSFTNGP12.phx.gbl...
Hi Greg thanks for responding. I wish I could tell you something that went
wrong. I can't. There were no errors of any kind. None. So I assume from
that all the SQL Server connections were correct. But I have no products at
all. I looked in the table in SQL and they are all like Product1,
Product2,... and so on. But in any case I get nothing the login doesn't
work (I can login by chossinng add a user and just hit submit) at all and
all in all it just doesn't work. Oh well I thought maybe someone here may
have tried this example in the past and could tell me what they did to get
it to work. If they said, "Well I followed the directions" then actually
that would be enough for me since I did change the connection string to
allow IUSR_MachineName to connect. But since I am not getting any
connection errors I assume the issue is not there.
--
George Hester
__________________________________
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:OEgMFnbyDHA.540@.tk2msftngp13.phx.gbl...
> Hi George.
> That's a very open question - could you perhaps define it a bit by
> describing the actual problem you're experiencing?
> Keep in mind that this is a SQL Server newsgroup & perhaps any VB/COM
> aspects of your question may be better asked in their respective
newsgroups.
> Otherwise, seasons greetings!
> Regards,
> Greg Linwood
> SQL Server MVP
> "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:%23V3HDGbyDHA.2620@.TK2MSFTNGP09.phx.gbl...
>
http://www.microsoft.com/downloads/details.aspx?familyid=b34a83f1-8fd3-4a1e-a423-e2cb0c16c0a8&displaylang=en
> Could someone explain where this application goes wrong and let me know
> where to set it right. It does not work as written. The VBCOM+SQL part.
> Thanks.
> --
> George Hester
> __________________________________
>|||OK thanks you gave me some ideas on where to "poke" or "peek" as the =case may be. I hate it when we run something that is errorless but =don't work. If there was an error I'd at least know where to start. It =might be in the COM dll. The directions were a little vague in that =part. I basically wung it.
-- George Hester
__________________________________
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message =news:eiLnehcyDHA.1908@.TK2MSFTNGP10.phx.gbl...
> Hi George.
> > I feel for you brother! I've been through similar experiences with =products
> that you download, hoping that things will just work straight up & =more
> times than not, there's something that bites you in the ass.. I guess =it at
> least helps us appreciate when things work as they should.
> > One thing I'd suggest is to use SQL Profiler to peek into the =background SQL
> Server activity. That way you'll at least get the opportunity to see =what's
> going on (if anything) at the SQL level. Other options may be to =attach the
> Win32 debugger to the VB process or other debuggers such as VC++, =softice
> etc - these will give you some insight into the VB executable's =activity.
> COM+ has a few GUI features that let you view activity within it's =runtime
> as well.. Perhaps using these tools, you might be able to at least =glean at
> what component levels things are / aren't happening.
> > HTH
> > Regards,
> Greg Linwood
> SQL Server MVP
> > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:emCrfRcyDHA.2148@.TK2MSFTNGP12.phx.gbl...
> Hi Greg thanks for responding. I wish I could tell you something that =went
> wrong. I can't. There were no errors of any kind. None. So I =assume from
> that all the SQL Server connections were correct. But I have no =products at
> all. I looked in the table in SQL and they are all like Product1,
> Product2,... and so on. But in any case I get nothing the login =doesn't
> work (I can login by chossinng add a user and just hit submit) at all =and
> all in all it just doesn't work. Oh well I thought maybe someone here =may
> have tried this example in the past and could tell me what they did to =get
> it to work. If they said, "Well I followed the directions" then =actually
> that would be enough for me since I did change the connection string =to
> allow IUSR_MachineName to connect. But since I am not getting any
> connection errors I assume the issue is not there.
> > -- > George Hester
> __________________________________
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:OEgMFnbyDHA.540@.tk2msftngp13.phx.gbl...
> > Hi George.
> >
> > That's a very open question - could you perhaps define it a bit by
> > describing the actual problem you're experiencing?
> >
> > Keep in mind that this is a SQL Server newsgroup & perhaps any =VB/COM
> > aspects of your question may be better asked in their respective
> newsgroups.
> >
> > Otherwise, seasons greetings!
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "George Hester" <hesterloli@.hotmail.com> wrote in message
> > news:%23V3HDGbyDHA.2620@.TK2MSFTNGP09.phx.gbl...
> >
> =http://www.microsoft.com/downloads/details.aspx?familyid=3Db34a83f1-8fd3-=
4a1e-a423-e2cb0c16c0a8&displaylang=3Den
> >
> > Could someone explain where this application goes wrong and let me =know
> > where to set it right. It does not work as written. The VBCOM+SQL =part.
> > Thanks.
> >
> > -- > > George Hester
> > __________________________________
> >
> >
> >|||Did you add IUSR_machinename as a valid SQL login?
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:%23V3HDGbyDHA.2620@.TK2MSFTNGP09.phx.gbl...
http://www.microsoft.com/downloads/details.aspx?familyid=b34a83f1-8fd3-4a1e-a423-e2cb0c16c0a8&displaylang=en
Could someone explain where this application goes wrong and let me know
where to set it right. It does not work as written. The VBCOM+SQL part.
Thanks.
--
George Hester
__________________________________

NEWID()

Hi,

Can someone explain the generation method of a uniqueidentifier in the NEWID() function ?

This number is generated using identification number of computer network card and an unique number from the CPU clock. (The network card is unique too)|||

Why do you care?

The uniqueidentifier is guaranteed to be a unique hex identifier. It is not sequential and cannot be used for any other purpose than a unique id of an object or record.

|||

Check out the following topics for description on the Win32API that SQL Server uses for NEWID and NEWSEQUENTIALID. The actual algorithm details can be found on the web.

http://msdn2.microsoft.com/en-us/library/aa379205.aspx

http://msdn2.microsoft.com/en-us/library/aa379322.aspx

NEWBY question - filtering dates

Im not sure how to explain this or if this is the correct forum but here it goes.

I have created a report from a view that gives me court hearing dates on a defendent. When I run the report/view I get two different dates for the person such as, 12/14/2006 and 12/15/2006. How can I get it to show only the later date (12/15/2006)? I pull information from a mainframe that almost always gives me 2 different dates, but we only need the most recent date.

Here is my query for the view

SELECT dbo.CASES.CaseID, dbo.CASENUMBERS.CaseNumber AS Arrest_Number, dbo.CASENUMBERTYPES.CaseNumTypeCode AS Arrest_NumType,
CASENUMBERS_1.CaseNumber AS JN_Number, CASENUMBERTYPES_1.CaseNumTypeCode AS JN_NumType, dbo.ROLETYPES.RoleTypeDesc,
dbo.ACTORS.SIDNum, dbo.ACTORLOCATIONS.ActorLocDesc, dbo.CHARGENUMBER.ChargeDescription, dbo.DEFCHARGES.OffenseDate,
dbo.fnNameReverse(dbo.ACTORNAMES.LastName, dbo.ACTORNAMES.FirstName, dbo.ACTORNAMES.MiddleName, dbo.ACTORNAMES.Suffix)
AS NameRev, dbo.EVENTS.ev_StartDate AS PreHearingSetDate, dbo.OFFENSELEVELS.OffenseLevelDesc, dbo.CASES.UnitID
FROM dbo.CASES INNER JOIN
dbo.CASENUMBERS ON dbo.CASES.CaseID = dbo.CASENUMBERS.CaseID INNER JOIN
dbo.CASENUMBERTYPES ON dbo.CASENUMBERS.CaseNumTypeID = dbo.CASENUMBERTYPES.CaseNumTypeID INNER JOIN
dbo.CASENUMBERS AS CASENUMBERS_1 ON dbo.CASES.CaseID = CASENUMBERS_1.CaseID INNER JOIN
dbo.CASENUMBERTYPES AS CASENUMBERTYPES_1 ON CASENUMBERS_1.CaseNumTypeID = CASENUMBERTYPES_1.CaseNumTypeID INNER JOIN
dbo.CASEPARTIES ON dbo.CASES.CaseID = dbo.CASEPARTIES.CaseID INNER JOIN
dbo.ROLETYPES ON dbo.CASEPARTIES.RoleTypeID = dbo.ROLETYPES.RoleTypeID AND
dbo.CASEPARTIES.RoleTypeID = dbo.ROLETYPES.RoleTypeID INNER JOIN
dbo.ACTORNAMES ON dbo.CASEPARTIES.ActorNameID = dbo.ACTORNAMES.ActorNameID INNER JOIN
dbo.ACTORS ON dbo.ACTORNAMES.ActorID = dbo.ACTORS.ActorID INNER JOIN
dbo.ACTORLOCATIONS ON dbo.ACTORS.ActorLocationID = dbo.ACTORLOCATIONS.ActorLocationID INNER JOIN
dbo.DEFCHARGESUMMARY ON dbo.CASES.CaseID = dbo.DEFCHARGESUMMARY.CasesCaseID INNER JOIN
dbo.DEFCHARGES ON dbo.DEFCHARGESUMMARY.DefChargeID = dbo.DEFCHARGES.DefChargeID INNER JOIN
dbo.CHARGENUMBER ON dbo.DEFCHARGES.ChargeNumberID = dbo.CHARGENUMBER.ChargeNumberID INNER JOIN
dbo.COURTS ON dbo.CASES.CaseCourtID = dbo.COURTS.CourtID INNER JOIN
dbo.EVENTS ON dbo.CASES.CaseID = dbo.EVENTS.CaseID INNER JOIN
dbo.EVENTTYPES ON dbo.EVENTS.EventTypeID = dbo.EVENTTYPES.EventTypeID INNER JOIN
dbo.OFFENSELEVELS ON dbo.CHARGENUMBER.OffenseLevelID = dbo.OFFENSELEVELS.OffenseLevelID
WHERE (dbo.CASENUMBERTYPES.CaseNumTypeCode = 'NM' OR
dbo.CASENUMBERTYPES.CaseNumTypeCode = 'MC' OR
dbo.CASENUMBERTYPES.CaseNumTypeCode = 'CM' OR
dbo.CASENUMBERTYPES.CaseNumTypeCode = 'JP') AND (CASENUMBERTYPES_1.CaseNumTypeCode = 'JN') AND
(dbo.ROLETYPES.RoleTypeDesc = 'Defendant') AND (dbo.EVENTTYPES.EventTypeDesc = 'PRE-HEARING SET') AND
(dbo.DEFCHARGES.OffenseDate > CONVERT(DATETIME, '2006-01-01 00:00:00', 102))

In the 'PRE-HEARING SET' table is where I receive the two dates. Is there a way to filter out the first date? I just want to show the most recent date.

Hi,

as you do not SELECT anything from the events table what about:

--dbo.EVENTTYPES ON dbo.EVENTS.EventTypeID = dbo.EVENTTYPES.EventTypeID INNER JOIN

dbo.OFFENSELEVELS ON dbo.CHARGENUMBER.OffenseLevelID = dbo.OFFENSELEVELS.OffenseLevelID

WHERE (dbo.CASENUMBERTYPES.CaseNumTypeCode = 'NM' OR

dbo.CASENUMBERTYPES.CaseNumTypeCode = 'MC' OR

dbo.CASENUMBERTYPES.CaseNumTypeCode = 'CM' OR

dbo.CASENUMBERTYPES.CaseNumTypeCode = 'JP') AND (CASENUMBERTYPES_1.CaseNumTypeCode = 'JN') AND

(dbo.ROLETYPES.RoleTypeDesc = 'Defendant') AND

(dbo.DEFCHARGES.OffenseDate > CONVERT(DATETIME, '2006-01-01 00:00:00', 102))

AND EXISTS(SELECT * FROM dbo.EVENTTYPES WHERE EVENTS.EventTypeID = dbo.EVENTTYPES.EventTypeID AND dbo.EVENTTYPES.EventTypeDesc = 'PRE-HEARING SET')

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de