databse restore

Hello,
I have situation where I will need to restore from.
Monday -- Full backup + Transaction Log ever hour
Tuesday -- Deferential Backup +Transaction Log ever hour
Wednesday --Deferential Backup Transaction Log ever hour at 7 PM database
suspect and I will need to restore from my backup
Do I go and restore Full backup + deferential backup of Tuesday +
deferential Backup of Wednesday + Transaction log that was taken after that
deferential backup on Wednesday ?
Thanks,Hello,
I would recommend to find out first why database became suspect and fix that
problem. To restore use Monday full backup, the last differential backup
(Wednesday) and all the transaction log backups since the last differential
backup.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Ron A" wrote:
> Hello,
>
> I have situation where I will need to restore from.
>
> Monday -- Full backup + Transaction Log ever hour
>
> Tuesday -- Deferential Backup +Transaction Log ever hour
>
> Wednesday --Deferential Backup Transaction Log ever hour at 7 PM database
> suspect and I will need to restore from my backup
>
> Do I go and restore Full backup + deferential backup of Tuesday +
> deferential Backup of Wednesday + Transaction log that was taken after that
> deferential backup on Wednesday ?
>
> Thanks,
>
>|||Ron
How about restoring FULL backup + LOG backup at 7PM ( I assume you took
backup log file just after a database became corrupted)
"Ron A" <omranu@.Gmail.com> wrote in message
news:er$LhgoHIHA.2100@.TK2MSFTNGP03.phx.gbl...
> Hello,
>
> I have situation where I will need to restore from.
>
> Monday -- Full backup + Transaction Log ever hour
>
> Tuesday -- Deferential Backup +Transaction Log ever hour
>
> Wednesday --Deferential Backup Transaction Log ever hour at 7 PM
> database suspect and I will need to restore from my backup
>
> Do I go and restore Full backup + deferential backup of Tuesday +
> deferential Backup of Wednesday + Transaction log that was taken after
> that deferential backup on Wednesday ?
>
> Thanks,
>
>

Databases missing from Backup Task of Maintenance Plan

I'm moving databases from SQL7 to another server with SQL2005.

I have created new databases in SQL2005 via a restore from backup files created in the old server. Now I want to back up these new databases but they don't show in the Backup Task of a new or existing Maintenance Plan in Management Studio. I can backup them manually though. Any ideas?

I assume you have restored this database to a local 2005 server. If this is the case, they should show up. Maintenance plans can not make connections to SQL 7. Can you see this database via Management Studio?|||

Rob,

Yes, that's correct. I restored the databases to another server running SQL2005. None of the databases show up in any task of Management Studio's Maintenance Plans (eg Backup, Shrink, ReOrg)

-Bill

|||

Found the problem - the compatibility level was set to SQL Server 7.0 by default ( under database properties->options). As soon as I changed the compatiblity level to SQL Server 2000, the databases showed up in the Maintenance Plan tasks.

Thank you for your responses.

Database will not restore from backup

have a production database running on SQL 2000 Enterprise with service pack
3, that until monday had a DTS package copying to another SQL Server for
development work. On monday a developer ran the package manually and it
failed with the error message "bulk copy transaction failed" error code
80045707. Since then it will not copy the database to the other SQL instance.
Tried to restore the databse on the same SQL instance to another database
name but the restore hangs with the message "loading".
I cannot put the database in into restricted access with SQL Enterprise
Management.
I have run DBCC DBCHECK and get no error reported.
Any suggestions?
Regards
Drew
I can do a restore of the database but still cannot run the DTS package to
copy the database even on the same server.
"drew" wrote:

> have a production database running on SQL 2000 Enterprise with service pack
> 3, that until monday had a DTS package copying to another SQL Server for
> development work. On monday a developer ran the package manually and it
> failed with the error message "bulk copy transaction failed" error code
> 80045707. Since then it will not copy the database to the other SQL instance.
> Tried to restore the databse on the same SQL instance to another database
> name but the restore hangs with the message "loading".
> I cannot put the database in into restricted access with SQL Enterprise
> Management.
> I have run DBCC DBCHECK and get no error reported.
>
> Any suggestions?
>
> Regards
> Drew
|||Hi,
Can you execute the Restore database using Query analyzer .
1. Using Restore filelistonly command identify the logical file names of the
database backup file
RESTORE FILELISTONLY from disk='c:\backup\dbname.bak'
2. With the output of the above query use RESTORE database
RESTORE DATABASE <newdbname> from disk='c:\backup\dbname.bak'
WITH move 'logical_mdf_filename' to 'new physical name with path',
move 'logical_ldf_filename' to 'new physical log name withpa
th',stats=10
Stats=10 will show the progress of restore.
Thanks
Hari
MCDBA
"drew" <drew@.discussions.microsoft.com> wrote in message
news:78023771-E516-4373-A1D3-BC922A4397D4@.microsoft.com...
> have a production database running on SQL 2000 Enterprise with service
> pack
> 3, that until monday had a DTS package copying to another SQL Server for
> development work. On monday a developer ran the package manually and it
> failed with the error message "bulk copy transaction failed" error code>
> 80045707. Since then it will not copy the database to the other SQL
> instance.
> Tried to restore the databse on the same SQL instance to another database
> name but the restore hangs with the message "loading".
> I cannot put the database in into restricted access with SQL Enterprise
> Management.
> I have run DBCC DBCHECK and get no error reported.
>
> Any suggestions?
>
> Regards
> Drew
|||I have managed to get the backup working. I am now trying to figure out why
the DTS package is failing. The paackage stops at the same table each time so
I will try and copy the database between servers less that table to see if
that clears the problem.
Thanks Drew
"Hari Prasad" wrote:

> Hi,
> Can you execute the Restore database using Query analyzer .
> 1. Using Restore filelistonly command identify the logical file names of the
> database backup file
> RESTORE FILELISTONLY from disk='c:\backup\dbname.bak'
> 2. With the output of the above query use RESTORE database
> RESTORE DATABASE <newdbname> from disk='c:\backup\dbname.bak'
> WITH move 'logical_mdf_filename' to 'new physical name with path',
> move 'logical_ldf_filename' to 'new physical log name withpa
> th',stats=10
> Stats=10 will show the progress of restore.
> Thanks
> Hari
> MCDBA
>
> "drew" <drew@.discussions.microsoft.com> wrote in message
> news:78023771-E516-4373-A1D3-BC922A4397D4@.microsoft.com...
>
>

Database will not restore from backup

have a production database running on SQL 2000 Enterprise with service pack
3, that until monday had a DTS package copying to another SQL Server for
development work. On monday a developer ran the package manually and it
failed with the error message "bulk copy transaction failed" error code
80045707. Since then it will not copy the database to the other SQL instance.
Tried to restore the databse on the same SQL instance to another database
name but the restore hangs with the message "loading".
I cannot put the database in into restricted access with SQL Enterprise
Management.
I have run DBCC DBCHECK and get no error reported.
Any suggestions?
Regards
DrewI can do a restore of the database but still cannot run the DTS package to
copy the database even on the same server.
"drew" wrote:
> have a production database running on SQL 2000 Enterprise with service pack
> 3, that until monday had a DTS package copying to another SQL Server for
> development work. On monday a developer ran the package manually and it
> failed with the error message "bulk copy transaction failed" error code
> 80045707. Since then it will not copy the database to the other SQL instance.
> Tried to restore the databse on the same SQL instance to another database
> name but the restore hangs with the message "loading".
> I cannot put the database in into restricted access with SQL Enterprise
> Management.
> I have run DBCC DBCHECK and get no error reported.
>
> Any suggestions?
>
> Regards
> Drew|||Hi,
Can you execute the Restore database using Query analyzer .
1. Using Restore filelistonly command identify the logical file names of the
database backup file
RESTORE FILELISTONLY from disk='c:\backup\dbname.bak'
2. With the output of the above query use RESTORE database
RESTORE DATABASE <newdbname> from disk='c:\backup\dbname.bak'
WITH move 'logical_mdf_filename' to 'new physical name with path',
move 'logical_ldf_filename' to 'new physical log name withpa
th',stats=10
Stats=10 will show the progress of restore.
Thanks
Hari
MCDBA
"drew" <drew@.discussions.microsoft.com> wrote in message
news:78023771-E516-4373-A1D3-BC922A4397D4@.microsoft.com...
> have a production database running on SQL 2000 Enterprise with service
> pack
> 3, that until monday had a DTS package copying to another SQL Server for
> development work. On monday a developer ran the package manually and it
> failed with the error message "bulk copy transaction failed" error code>
> 80045707. Since then it will not copy the database to the other SQL
> instance.
> Tried to restore the databse on the same SQL instance to another database
> name but the restore hangs with the message "loading".
> I cannot put the database in into restricted access with SQL Enterprise
> Management.
> I have run DBCC DBCHECK and get no error reported.
>
> Any suggestions?
>
> Regards
> Drew|||I have managed to get the backup working. I am now trying to figure out why
the DTS package is failing. The paackage stops at the same table each time so
I will try and copy the database between servers less that table to see if
that clears the problem.
Thanks Drew
"Hari Prasad" wrote:
> Hi,
> Can you execute the Restore database using Query analyzer .
> 1. Using Restore filelistonly command identify the logical file names of the
> database backup file
> RESTORE FILELISTONLY from disk='c:\backup\dbname.bak'
> 2. With the output of the above query use RESTORE database
> RESTORE DATABASE <newdbname> from disk='c:\backup\dbname.bak'
> WITH move 'logical_mdf_filename' to 'new physical name with path',
> move 'logical_ldf_filename' to 'new physical log name withpa
> th',stats=10
> Stats=10 will show the progress of restore.
> Thanks
> Hari
> MCDBA
>
> "drew" <drew@.discussions.microsoft.com> wrote in message
> news:78023771-E516-4373-A1D3-BC922A4397D4@.microsoft.com...
> > have a production database running on SQL 2000 Enterprise with service
> > pack
> > 3, that until monday had a DTS package copying to another SQL Server for
> > development work. On monday a developer ran the package manually and it
> > failed with the error message "bulk copy transaction failed" error code>
> > 80045707. Since then it will not copy the database to the other SQL
> > instance.
> >
> > Tried to restore the databse on the same SQL instance to another database
> > name but the restore hangs with the message "loading".
> >
> > I cannot put the database in into restricted access with SQL Enterprise
> > Management.
> >
> > I have run DBCC DBCHECK and get no error reported.
> >
> >
> >
> > Any suggestions?
> >
> >
> > Regards
> >
> > Drew
>
>

Database users after restore

We restore a production database (with around 50 users) to
a Training database on another SQL 2000 Server.
However, we find that those users on the Training Database
disappear (All has been lost except SA). However, from
one Database Role, it shows that those users (around 50)
still are members of that role.
Is it sensible for those database users disappear (As
there is no corresponding SQL Server Login created for
them) OR how can I get back those users ?
ThanksThey have a mis-match to the id for the logins in master..syslogins. Use sp_change_users_locing to
fix. There's a free GUI for that available at http://www.dbmaint.com/free_utilities.asp.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Roger Lee" <rogerlee@.nospam.com> wrote in message news:093501c36601$7bec4cb0$a301280a@.phx.gbl...
> We restore a production database (with around 50 users) to
> a Training database on another SQL 2000 Server.
> However, we find that those users on the Training Database
> disappear (All has been lost except SA). However, from
> one Database Role, it shows that those users (around 50)
> still are members of that role.
> Is it sensible for those database users disappear (As
> there is no corresponding SQL Server Login created for
> them) OR how can I get back those users ?
> Thanks|||>--Original Message--
>We restore a production database (with around 50 users)
to
>a Training database on another SQL 2000 Server.
>However, we find that those users on the Training
Database
>disappear (All has been lost except SA). However, from
>one Database Role, it shows that those users (around 50)
>still are members of that role.
>Is it sensible for those database users disappear (As
>there is no corresponding SQL Server Login created for
>them) OR how can I get back those users ?
>Thanks
>.
>You can copy across users/logins from the other DB using
DTS.