Stuart McLachlan
stuart at lexacorp.com.pg
Sun Jan 23 07:33:41 CST 2011
I didn't mean a backup in SQL Server, that's why I said shut down the service first. Just copy the database files somewhere else for safety. -- Stuart On 23 Jan 2011 at 8:01, jwcolby wrote: > I can't even do a backup. It gives me a "login failed - error 4064" > > John W. Colby > www.ColbyConsulting.com > > On 1/23/2011 12:52 AM, Stuart McLachlan wrote: > > When you delete a use and create a new one with the same name, that > > is NOT the same user. It has a different Security ID (SID). > > > > You will need to give rights to the new user all over again. > > > > One solution would be to shut down the SQL Server service, backup > > the database files then create a new instance and attach the > > databases to it. > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >