Re: No Database Backup Securtiy

From: Amol Gawde (agawde_at_remittag.com)
Date: 07/01/03


Date: Tue, 1 Jul 2003 19:05:20 +0530


Thanks

"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message
news:072c01c33fb1$44ff7720$a501280a@phx.gbl...
> You can place a password on your backup files.
>
> HTH
>
> Ray Higdon MCSE, MCDBA, CCNA
>
> >-----Original Message-----
> >I have observed the following problem with SQL Databse
> >Backup.
> >
> >1. I have got a Server which has SA with a password.
> >2. Backup was taken for one of the database from the
> Same
> >server.
> >3. Now If I use the same database restore on some other
> >SQL server which has got some different password for SA.
> >4. It allows me to restore the same without any problem.
> >5. As a result my security is lost becouse I wanted that
> >even while restoring the database it should ask me the
> SA
> >password which was their while taking the backup.
> >
> >Regards
> >
> >Amol
> >
> >.
> >



Relevant Pages

  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • RE: SQL server restore
    ... there is possiblly a database ... As for the SQL Server 2000 work on the Server A, ... restore the backups on it. ... restore from the backup). ...
    (microsoft.public.sqlserver.server)
  • Re: Restore database
    ... Initialize the backup device with INIT. ... My database is very small. ... Microsoft SQL Server Management Studio Express ... Restore failed for Server 'HOMEDEV\SQLEXPRESS'. ...
    (microsoft.public.sqlserver.setup)
  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: restore permissions to a login
    ... restore the database. ... what about SQL Server installations that use ... > I have run into a situation that a 3rd party backup and restore solution ... > database roles and database_creators server role. ...
    (microsoft.public.sqlserver.server)

Quantcast