Copy Database?

I am trying to create a backup of our production database, but a restore of
the backup doesn't seem to be grabbing everything (and I'm not sure what
it's missing, I just know things aren't working properly in the backup
database). Anyway, I was wondering if there is a way of copying EVERYTHING
from the live database without taking it offline. I tried the Copy Database
Wizard, but it chokes and dies if anybody is connected to the database. Any
suggestions would be greatly appreciated.
Willie Bodger
A backup does copy everything in the database and is the preferred way to do
what you are attempting. When you give details like "things aren't working
properly" it is pretty hard for someone to give you a correct response to
your problem. I will guess and say you have issues with the users not
matching up to the Logins. Logins are server level and do not come over
with the db but the users do. These should help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Willie Bodger" <willie@.bodgerfam.com> wrote in message
news:Oe3aNZwNFHA.3716@.TK2MSFTNGP14.phx.gbl...
>I am trying to create a backup of our production database, but a restore of
>the backup doesn't seem to be grabbing everything (and I'm not sure what
>it's missing, I just know things aren't working properly in the backup
>database). Anyway, I was wondering if there is a way of copying EVERYTHING
>from the live database without taking it offline. I tried the Copy Database
>Wizard, but it chokes and dies if anybody is connected to the database. Any
>suggestions would be greatly appreciated.
> Willie Bodger
>
|||For instance, when I try to run a stored procedure, I get this error:
OLE Automation Error Information
HRESULT: 0x800401f3
Source: ODSOLE Extended Procedure
Description: Invalid class string
error! 1
Any thoughts, or is there still too little info?
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:e0LMjkwNFHA.3076@.TK2MSFTNGP14.phx.gbl...
>A backup does copy everything in the database and is the preferred way to
>do what you are attempting. When you give details like "things aren't
>working properly" it is pretty hard for someone to give you a correct
>response to your problem. I will guess and say you have issues with the
>users not matching up to the Logins. Logins are server level and do not
>come over with the db but the users do. These should help:
> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://www.support.microsoft.com/?id=314546 Moving DB's between
> Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server
> Databases to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
> a Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or
> Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scri...p?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly SQL MVP
>
> "Willie Bodger" <willie@.bodgerfam.com> wrote in message
> news:Oe3aNZwNFHA.3716@.TK2MSFTNGP14.phx.gbl...
>
|||You are attempting to execute a non-native (ie: user created) sql server
extended stored procedure. They too are at the server level and not part of
the database. They are simply files on the hard drive and you are
responsible for copying them over as well. Since these are basically DLL's
it could be almost anything depending on how it was coded and what else it
is dependant on. I would find who created it and see what they have to say.
Andrew J. Kelly SQL MVP
"Willie Bodger" <willie@.bodgerfam.com> wrote in message
news:OYrqYexNFHA.3156@.TK2MSFTNGP15.phx.gbl...
> For instance, when I try to run a stored procedure, I get this error:
> OLE Automation Error Information
> HRESULT: 0x800401f3
> Source: ODSOLE Extended Procedure
> Description: Invalid class string
> error! 1
> Any thoughts, or is there still too little info?
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:e0LMjkwNFHA.3076@.TK2MSFTNGP14.phx.gbl...
>