Autonumber field: safe

Showing posts with label safe. Show all posts

Sunday, March 25, 2012

Backing up logins info/data

We currently backup the system databases, user databases and logs every nigh
t
To be on the safe side should we also backup the logins data, in case we
have to recreate the master database ?
If so what would be the best approach to backup the logins info/data ?
ThanksHi
You can generate script of Logins by using sp_help_revlogin (search on
internet)
"SQL Server newbie" <SQLServernewbie@.discussions.microsoft.com> wrote in
message news:62AEF9F6-6A8E-4D9D-BD59-0B5E48A7D408@.microsoft.com...
> We currently backup the system databases, user databases and logs every
> night
> To be on the safe side should we also backup the logins data, in case we
> have to recreate the master database ?
> If so what would be the best approach to backup the logins info/data ?
> Thanks|||Logins are in the master database, so these are included in the backup of th
e master database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"SQL Server newbie" <SQLServernewbie@.discussions.microsoft.com> wrote in mes
sage
news:62AEF9F6-6A8E-4D9D-BD59-0B5E48A7D408@.microsoft.com...
> We currently backup the system databases, user databases and logs every ni
ght
> To be on the safe side should we also backup the logins data, in case we
> have to recreate the master database ?
> If so what would be the best approach to backup the logins info/data ?
> Thankssql

Backing up logins info/data

We currently backup the system databases, user databases and logs every night
To be on the safe side should we also backup the logins data, in case we
have to recreate the master database ?
If so what would be the best approach to backup the logins info/data ?
Thanks
Hi
You can generate script of Logins by using sp_help_revlogin (search on
internet)
"SQL Server newbie" <SQLServernewbie@.discussions.microsoft.com> wrote in
message news:62AEF9F6-6A8E-4D9D-BD59-0B5E48A7D408@.microsoft.com...
> We currently backup the system databases, user databases and logs every
> night
> To be on the safe side should we also backup the logins data, in case we
> have to recreate the master database ?
> If so what would be the best approach to backup the logins info/data ?
> Thanks
|||Logins are in the master database, so these are included in the backup of the master database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"SQL Server newbie" <SQLServernewbie@.discussions.microsoft.com> wrote in message
news:62AEF9F6-6A8E-4D9D-BD59-0B5E48A7D408@.microsoft.com...
> We currently backup the system databases, user databases and logs every night
> To be on the safe side should we also backup the logins data, in case we
> have to recreate the master database ?
> If so what would be the best approach to backup the logins info/data ?
> Thanks

Backing up logins info/data

We currently backup the system databases, user databases and logs every night
To be on the safe side should we also backup the logins data, in case we
have to recreate the master database ?
If so what would be the best approach to backup the logins info/data ?
ThanksHi
You can generate script of Logins by using sp_help_revlogin (search on
internet)
"SQL Server newbie" <SQLServernewbie@.discussions.microsoft.com> wrote in
message news:62AEF9F6-6A8E-4D9D-BD59-0B5E48A7D408@.microsoft.com...
> We currently backup the system databases, user databases and logs every
> night
> To be on the safe side should we also backup the logins data, in case we
> have to recreate the master database ?
> If so what would be the best approach to backup the logins info/data ?
> Thanks|||Logins are in the master database, so these are included in the backup of the master database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"SQL Server newbie" <SQLServernewbie@.discussions.microsoft.com> wrote in message
news:62AEF9F6-6A8E-4D9D-BD59-0B5E48A7D408@.microsoft.com...
> We currently backup the system databases, user databases and logs every night
> To be on the safe side should we also backup the logins data, in case we
> have to recreate the master database ?
> If so what would be the best approach to backup the logins info/data ?
> Thanks

Wednesday, March 7, 2012

AWE and the SP4...

When the SQL Server SP4 was released I was informed it had some issues with
AWE.
Is those issues are still exist? Is it safe to installs SP4? My SQL Server
installation left with default AWE settings (value of 0). Since AWE is not
enabled, applying SP4 should not be any issue in my case.
Thanks,
LarryHi
No problem for you. You do not have to apply the patch to bring you to
version 2040 from 2039
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/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:O0GnXdgxFHA.2136@.TK2MSFTNGP10.phx.gbl...
> When the SQL Server SP4 was released I was informed it had some issues
> with
> AWE.
> Is those issues are still exist? Is it safe to installs SP4? My SQL
> Server
> installation left with default AWE settings (value of 0). Since AWE is
> not
> enabled, applying SP4 should not be any issue in my case.
> Thanks,
> Larry
>|||You are suggesting that I can live without SP4?
See the link below what Microsoft says....
http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.mspx
This link prompted me to apply the SP4.
What is version 2039/2040? My SQL Server installation says 8.00.760
'
Thank you,
Larry
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:Oj%23tNugxFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi
> No problem for you. You do not have to apply the patch to bring you to
> version 2040 from 2039
> 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/
> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
> news:O0GnXdgxFHA.2136@.TK2MSFTNGP10.phx.gbl...
> > When the SQL Server SP4 was released I was informed it had some issues
> > with
> > AWE.
> >
> > Is those issues are still exist? Is it safe to installs SP4? My SQL
> > Server
> > installation left with default AWE settings (value of 0). Since AWE is
> > not
> > enabled, applying SP4 should not be any issue in my case.
> >
> > Thanks,
> >
> > Larry
> >
> >
>|||Hi
No. Apply SP4, but if you are not using AWE memory, you do not have to apply
the hotfix to SP4 to fix the AWE memory issue.
8.00.2039 = SP4
You currently have SP3 installed.
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/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:e67oU$gxFHA.3300@.TK2MSFTNGP09.phx.gbl...
> You are suggesting that I can live without SP4?
> See the link below what Microsoft says....
> http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.mspx
> This link prompted me to apply the SP4.
> What is version 2039/2040? My SQL Server installation says 8.00.760
> '
> Thank you,
> Larry
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:Oj%23tNugxFHA.2212@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> No problem for you. You do not have to apply the patch to bring you to
>> version 2040 from 2039
>> 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/
>> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
>> news:O0GnXdgxFHA.2136@.TK2MSFTNGP10.phx.gbl...
>> > When the SQL Server SP4 was released I was informed it had some issues
>> > with
>> > AWE.
>> >
>> > Is those issues are still exist? Is it safe to installs SP4? My SQL
>> > Server
>> > installation left with default AWE settings (value of 0). Since AWE is
>> > not
>> > enabled, applying SP4 should not be any issue in my case.
>> >
>> > Thanks,
>> >
>> > Larry
>> >
>> >
>>
>|||Thank you for the suggestion.
How did you derive the equation "8.00.2039 = SP4" ?
Thank you,
Larry
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23u786BhxFHA.3188@.TK2MSFTNGP14.phx.gbl...
> Hi
> No. Apply SP4, but if you are not using AWE memory, you do not have to
apply
> the hotfix to SP4 to fix the AWE memory issue.
> 8.00.2039 = SP4
> You currently have SP3 installed.
> 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/
> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
> news:e67oU$gxFHA.3300@.TK2MSFTNGP09.phx.gbl...
> > You are suggesting that I can live without SP4?
> > See the link below what Microsoft says....
> >
http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.mspx
> > This link prompted me to apply the SP4.
> > What is version 2039/2040? My SQL Server installation says 8.00.760
> > '
> > Thank you,
> > Larry
> >
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> > news:Oj%23tNugxFHA.2212@.TK2MSFTNGP15.phx.gbl...
> >> Hi
> >>
> >> No problem for you. You do not have to apply the patch to bring you to
> >> version 2040 from 2039
> >>
> >> 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/
> >>
> >> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
> >> news:O0GnXdgxFHA.2136@.TK2MSFTNGP10.phx.gbl...
> >> > When the SQL Server SP4 was released I was informed it had some
issues
> >> > with
> >> > AWE.
> >> >
> >> > Is those issues are still exist? Is it safe to installs SP4? My SQL
> >> > Server
> >> > installation left with default AWE settings (value of 0). Since AWE
is
> >> > not
> >> > enabled, applying SP4 should not be any issue in my case.
> >> >
> >> > Thanks,
> >> >
> >> > Larry
> >> >
> >> >
> >>
> >>
> >
> >
>|||Hi
The outdated list http://www.aspfaq.com/show.asp?id=2160 and
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185 and from
installing it and looking at the version numbers.
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/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OaYHIGhxFHA.2728@.TK2MSFTNGP14.phx.gbl...
> Thank you for the suggestion.
> How did you derive the equation "8.00.2039 = SP4" ?
> Thank you,
> Larry
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23u786BhxFHA.3188@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> No. Apply SP4, but if you are not using AWE memory, you do not have to
> apply
>> the hotfix to SP4 to fix the AWE memory issue.
>> 8.00.2039 = SP4
>> You currently have SP3 installed.
>> 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/
>> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
>> news:e67oU$gxFHA.3300@.TK2MSFTNGP09.phx.gbl...
>> > You are suggesting that I can live without SP4?
>> > See the link below what Microsoft says....
>> >
> http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.mspx
>> > This link prompted me to apply the SP4.
>> > What is version 2039/2040? My SQL Server installation says 8.00.760
>> > '
>> > Thank you,
>> > Larry
>> >
>> >
>> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
>> > news:Oj%23tNugxFHA.2212@.TK2MSFTNGP15.phx.gbl...
>> >> Hi
>> >>
>> >> No problem for you. You do not have to apply the patch to bring you to
>> >> version 2040 from 2039
>> >>
>> >> 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/
>> >>
>> >> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
>> >> news:O0GnXdgxFHA.2136@.TK2MSFTNGP10.phx.gbl...
>> >> > When the SQL Server SP4 was released I was informed it had some
> issues
>> >> > with
>> >> > AWE.
>> >> >
>> >> > Is those issues are still exist? Is it safe to installs SP4? My SQL
>> >> > Server
>> >> > installation left with default AWE settings (value of 0). Since AWE
> is
>> >> > not
>> >> > enabled, applying SP4 should not be any issue in my case.
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Larry
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>|||Thank you,
Larry
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:epVvHNhxFHA.3236@.TK2MSFTNGP14.phx.gbl...
> Hi
> The outdated list http://www.aspfaq.com/show.asp?id=2160 and
> http://support.microsoft.com/default.aspx?scid=kb;en-us;321185 and from
> installing it and looking at the version numbers.
> 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/
> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
> news:OaYHIGhxFHA.2728@.TK2MSFTNGP14.phx.gbl...
> > Thank you for the suggestion.
> > How did you derive the equation "8.00.2039 = SP4" ?
> > Thank you,
> > Larry
> >
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> > news:%23u786BhxFHA.3188@.TK2MSFTNGP14.phx.gbl...
> >> Hi
> >>
> >> No. Apply SP4, but if you are not using AWE memory, you do not have to
> > apply
> >> the hotfix to SP4 to fix the AWE memory issue.
> >>
> >> 8.00.2039 = SP4
> >>
> >> You currently have SP3 installed.
> >>
> >> 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/
> >>
> >> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
> >> news:e67oU$gxFHA.3300@.TK2MSFTNGP09.phx.gbl...
> >> > You are suggesting that I can live without SP4?
> >> > See the link below what Microsoft says....
> >> >
> >
http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.mspx
> >> > This link prompted me to apply the SP4.
> >> > What is version 2039/2040? My SQL Server installation says 8.00.760
> >> > '
> >> > Thank you,
> >> > Larry
> >> >
> >> >
> >> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> >> > news:Oj%23tNugxFHA.2212@.TK2MSFTNGP15.phx.gbl...
> >> >> Hi
> >> >>
> >> >> No problem for you. You do not have to apply the patch to bring you
to
> >> >> version 2040 from 2039
> >> >>
> >> >> 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/
> >> >>
> >> >> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
> >> >> news:O0GnXdgxFHA.2136@.TK2MSFTNGP10.phx.gbl...
> >> >> > When the SQL Server SP4 was released I was informed it had some
> > issues
> >> >> > with
> >> >> > AWE.
> >> >> >
> >> >> > Is those issues are still exist? Is it safe to installs SP4? My
SQL
> >> >> > Server
> >> >> > installation left with default AWE settings (value of 0). Since
AWE
> > is
> >> >> > not
> >> >> > enabled, applying SP4 should not be any issue in my case.
> >> >> >
> >> >> > Thanks,
> >> >> >
> >> >> > Larry
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>

Sunday, March 25, 2012

Backing up logins info/data

Backing up logins info/data

Backing up logins info/data

Wednesday, March 7, 2012

AWE and the SP4...

AWE and the SP4...

AWE and the SP4...

Autonumber field

Blog Archive

About Me