Re: sql 2008 evaluation edition upgrade

Thanks! that explains alot.

"Ekrem Önsoy" wrote:

When you were saying "backup" I thought you were talking about backing up
your databases that's why I told you about BACKUP command.

If you want to transfer your Logins, you can use some scripts or SSIS' s
Transfer Logins. See the following links which are about transferring
logins.
http://technet.microsoft.com/en-us/library/ms137870.aspx
http://support.microsoft.com/kb/246133

Backing up system databases is a good thing to do to prevent server\system
level settings lose. For example master database includes your Logins,
Linked Servers, Endpoints etc. You should back up system databases when you
make a change that effects SQL Server system.

--
Ekrem Önsoy



"Jim B" <JimB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:470D8F33-6DAE-43EF-9F1C-816B1BAFCE5B@xxxxxxxxxxxxxxxx
Perhaps I am not understanding. Yuo mentioned that I had to use ssis to
restore logins. If I backup the system databases and restore will that
recover the logins?

"Ekrem Önsoy" wrote:

You do not have to use SSIS to backup\restore your databases.

I suggest you to see BACKUP and RESTORE commands from Books Online.
http://msdn.microsoft.com/en-us/library/ms186865(SQL.90).aspx

You also may want to use Maintanence Plans to backup your databases (not
recommended).

--
Ekrem Önsoy




"Jim B" <JimB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:756644EE-F83E-4D95-A542-868F7A3CD92E@xxxxxxxxxxxxxxxx
Is there a howto on doing a full backup and restore using backup and
SSIS?

"Ekrem Önsoy" wrote:

A database restore, restores only database level objects. You can
easily
transfer your Logins and other server level objects using SSIS.

Supported upgrade paths:
http://technet.microsoft.com/en-us/library/ms143393.aspx

--
Ekrem Önsoy



"Jim B" <JimB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:18582229-7C70-467A-887C-90B28F1E4225@xxxxxxxxxxxxxxxx
Let me put it another way, does a restore restore everything (users
logins
etc) or is that on a per database level? More importantly (not to
get
off
on
a tangent) where can I find out of upgrading to the RTM is a
supported
path.
I thought I read somewhere that the upgrade would be allowed.

"Aaron Bertrand [SQL Server MVP]" wrote:

Sorry, not a SharePoint guy, you might get better answers in a
SharePoint
newsgroup...


On 11/5/08 9:56 AM, in article
20DC5FA2-5C3B-48D4-84EB-851C68EF7704@xxxxxxxxxxxxx, "Jim B"
<JimB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I agree that an uninstall re-install would be preferable. This
sql
instance
will be supporting a shareppoint instance so if I did a backup,
uninstall,
install full version and restore what do you think the chances of
it
all
working at the end are?





.

Relevant Pages

  • Re: sql 2008 evaluation edition upgrade
    ... restore logins. ... I suggest you to see BACKUP and RESTORE commands from Books Online. ... You also may want to use Maintanence Plans to backup your databases (not ...
    (microsoft.public.sqlserver.setup)
  • Re: sql 2008 evaluation edition upgrade
    ... When you were saying "backup" I thought you were talking about backing up your databases that's why I told you about BACKUP command. ... If you want to transfer your Logins, you can use some scripts or SSIS' s Transfer Logins. ... restore logins. ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving SQL 7 DB to SQL 2000 on different machine
    ... I do a backup and restore. ... logins, ... Run the reconcile script. ...
    (microsoft.public.sqlserver.setup)
  • Re: Membership download
    ... SSIS task does not include the property for ALTER AUTHORIZATION ON SCHEMA. ... How to move databases between computers that are running SQL Server ... With SSIS transfer object task, if your destination server has no logins, ...
    (microsoft.public.sqlserver.dts)
  • RE: Copy Database Wizard
    ... Does the Backup and Restore take all of the logins, jobs, etc ... "Allan Mitchell" wrote: ... > Even though you have a few dbs to back up I would still be using BACKUP RESTORE ...
    (microsoft.public.sqlserver.dts)
Loading