help copying databases

I am trying to import all of my production databases onto my development
laptop which is running the same version of SQL SQL 2000. I can not get the
imports to complete. I have all kinds of login already has an account, or
invalid object, or foreign constraint error, or...,
There has got to be a better way of creating a duplicate of my production
databases on my development desktop. Can someone tell me what I am doing
wrong. Ideally, I would "dump" my production server to my develpment server
on a regular basis to keep my .net apps using real data and current
procedures.
Any help would be appreciated.
Currently I am trying to just "import" the databases. I have tried with
database logins, without database logins, with sql user accounts, without
sql user accounts and it is not working.
Thanks,
FredDid u try the DTS Imports wizard?
You can also try to backup the production database and "restore as" in your
laptop. Did you try that option?
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
news:uOMXO4tNFHA.3492@.TK2MSFTNGP09.phx.gbl...
> I am trying to import all of my production databases onto my development
> laptop which is running the same version of SQL SQL 2000. I can not get
the
> imports to complete. I have all kinds of login already has an account, or
> invalid object, or foreign constraint error, or...,
> There has got to be a better way of creating a duplicate of my production
> databases on my development desktop. Can someone tell me what I am doing
> wrong. Ideally, I would "dump" my production server to my develpment
server
> on a regular basis to keep my .net apps using real data and current
> procedures.
> Any help would be appreciated.
> Currently I am trying to just "import" the databases. I have tried with
> database logins, without database logins, with sql user accounts, without
> sql user accounts and it is not working.
> Thanks,
> Fred
>|||I don't recommend using the wizard. Simply restore a full backup and
address the logins and you should be all set.
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/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
news:uOMXO4tNFHA.3492@.TK2MSFTNGP09.phx.gbl...
>I am trying to import all of my production databases onto my development
>laptop which is running the same version of SQL SQL 2000. I can not get
>the imports to complete. I have all kinds of login already has an account,
>or invalid object, or foreign constraint error, or...,
> There has got to be a better way of creating a duplicate of my production
> databases on my development desktop. Can someone tell me what I am doing
> wrong. Ideally, I would "dump" my production server to my develpment
> server on a regular basis to keep my .net apps using real data and current
> procedures.
> Any help would be appreciated.
> Currently I am trying to just "import" the databases. I have tried with
> database logins, without database logins, with sql user accounts, without
> sql user accounts and it is not working.
> Thanks,
> Fred
>sql

help copying databases

I am trying to import all of my production databases onto my development
laptop which is running the same version of SQL SQL 2000. I can not get the
imports to complete. I have all kinds of login already has an account, or
invalid object, or foreign constraint error, or...,
There has got to be a better way of creating a duplicate of my production
databases on my development desktop. Can someone tell me what I am doing
wrong. Ideally, I would "dump" my production server to my develpment server
on a regular basis to keep my .net apps using real data and current
procedures.
Any help would be appreciated.
Currently I am trying to just "import" the databases. I have tried with
database logins, without database logins, with sql user accounts, without
sql user accounts and it is not working.
Thanks,
Fred
Did u try the DTS Imports wizard?
You can also try to backup the production database and "restore as" in your
laptop. Did you try that option?
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
news:uOMXO4tNFHA.3492@.TK2MSFTNGP09.phx.gbl...
> I am trying to import all of my production databases onto my development
> laptop which is running the same version of SQL SQL 2000. I can not get
the
> imports to complete. I have all kinds of login already has an account, or
> invalid object, or foreign constraint error, or...,
> There has got to be a better way of creating a duplicate of my production
> databases on my development desktop. Can someone tell me what I am doing
> wrong. Ideally, I would "dump" my production server to my develpment
server
> on a regular basis to keep my .net apps using real data and current
> procedures.
> Any help would be appreciated.
> Currently I am trying to just "import" the databases. I have tried with
> database logins, without database logins, with sql user accounts, without
> sql user accounts and it is not working.
> Thanks,
> Fred
>
|||I don't recommend using the wizard. Simply restore a full backup and
address the logins and you should be all set.
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
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
news:uOMXO4tNFHA.3492@.TK2MSFTNGP09.phx.gbl...
>I am trying to import all of my production databases onto my development
>laptop which is running the same version of SQL SQL 2000. I can not get
>the imports to complete. I have all kinds of login already has an account,
>or invalid object, or foreign constraint error, or...,
> There has got to be a better way of creating a duplicate of my production
> databases on my development desktop. Can someone tell me what I am doing
> wrong. Ideally, I would "dump" my production server to my develpment
> server on a regular basis to keep my .net apps using real data and current
> procedures.
> Any help would be appreciated.
> Currently I am trying to just "import" the databases. I have tried with
> database logins, without database logins, with sql user accounts, without
> sql user accounts and it is not working.
> Thanks,
> Fred
>

help copying databases

I am trying to import all of my production databases onto my development
laptop which is running the same version of SQL SQL 2000. I can not get the
imports to complete. I have all kinds of login already has an account, or
invalid object, or foreign constraint error, or...,
There has got to be a better way of creating a duplicate of my production
databases on my development desktop. Can someone tell me what I am doing
wrong. Ideally, I would "dump" my production server to my develpment server
on a regular basis to keep my .net apps using real data and current
procedures.
Any help would be appreciated.
Currently I am trying to just "import" the databases. I have tried with
database logins, without database logins, with sql user accounts, without
sql user accounts and it is not working.
Thanks,
FredDid u try the DTS Imports wizard?
You can also try to backup the production database and "restore as" in your
laptop. Did you try that option?
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
news:uOMXO4tNFHA.3492@.TK2MSFTNGP09.phx.gbl...
> I am trying to import all of my production databases onto my development
> laptop which is running the same version of SQL SQL 2000. I can not get
the
> imports to complete. I have all kinds of login already has an account, or
> invalid object, or foreign constraint error, or...,
> There has got to be a better way of creating a duplicate of my production
> databases on my development desktop. Can someone tell me what I am doing
> wrong. Ideally, I would "dump" my production server to my develpment
server
> on a regular basis to keep my .net apps using real data and current
> procedures.
> Any help would be appreciated.
> Currently I am trying to just "import" the databases. I have tried with
> database logins, without database logins, with sql user accounts, without
> sql user accounts and it is not working.
> Thanks,
> Fred
>|||I don't recommend using the wizard. Simply restore a full backup and
address the logins and you should be all set.
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/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
--
Andrew J. Kelly SQL MVP
"Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
news:uOMXO4tNFHA.3492@.TK2MSFTNGP09.phx.gbl...
>I am trying to import all of my production databases onto my development
>laptop which is running the same version of SQL SQL 2000. I can not get
>the imports to complete. I have all kinds of login already has an account,
>or invalid object, or foreign constraint error, or...,
> There has got to be a better way of creating a duplicate of my production
> databases on my development desktop. Can someone tell me what I am doing
> wrong. Ideally, I would "dump" my production server to my develpment
> server on a regular basis to keep my .net apps using real data and current
> procedures.
> Any help would be appreciated.
> Currently I am trying to just "import" the databases. I have tried with
> database logins, without database logins, with sql user accounts, without
> sql user accounts and it is not working.
> Thanks,
> Fred
>

HELP - problem after copying MDF and Log files

I had a problem where a log file was deleted. I managed to get the database
recovered on my own machine. I sent the MDF and Log files to the client so
he could stop SQL Server, copy the files and then start SQL Server again.
Now I can't get into SQL Server at all - it keeps telling me SQL Server does
not exist or access denied. I tried to delete the files that I copied (after
shutting down SQL Server) but it didn't work - on startup I still can't
access the SQL Server with any of the client tools. HELP!Which database was the log lost for? As long as it was not master or model
you may be able to use sp_attach_single_file_db.
Check if SQL Server is running.
If you did it to master or model, you have messed up the server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"claire" <claire@.discussions.microsoft.com> wrote in message
news:AE9EC5D3-724A-4480-8367-D85855839152@.microsoft.com...
> I had a problem where a log file was deleted. I managed to get the
database
> recovered on my own machine. I sent the MDF and Log files to the client
so
> he could stop SQL Server, copy the files and then start SQL Server again.
> Now I can't get into SQL Server at all - it keeps telling me SQL Server
does
> not exist or access denied. I tried to delete the files that I copied
(after
> shutting down SQL Server) but it didn't work - on startup I still can't
> access the SQL Server with any of the client tools. HELP!
>|||Stopping the server, copying the files then starting was probably not a good
idea.
If you had the database on your machine then sending a backup and gettig the
client to restore would have been a better option.
Check the sql server logs and application logs - you will probably see a
message to say what has happenned. It sounds like he has corrupted master,
model or done something to change the path of the system databases.
This is probably recoverable but you might be better off re-installing sql
server and attaching all the databases (try ttaching on another server first
to check integrity).
You then might want to look at your backup strategy in case this happens
again.

HELP - problem after copying MDF and Log files

I had a problem where a log file was deleted. I managed to get the database
recovered on my own machine. I sent the MDF and Log files to the client so
he could stop SQL Server, copy the files and then start SQL Server again.
Now I can't get into SQL Server at all - it keeps telling me SQL Server does
not exist or access denied. I tried to delete the files that I copied (after
shutting down SQL Server) but it didn't work - on startup I still can't
access the SQL Server with any of the client tools. HELP!
Which database was the log lost for? As long as it was not master or model
you may be able to use sp_attach_single_file_db.
Check if SQL Server is running.
If you did it to master or model, you have messed up the server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"claire" <claire@.discussions.microsoft.com> wrote in message
news:AE9EC5D3-724A-4480-8367-D85855839152@.microsoft.com...
> I had a problem where a log file was deleted. I managed to get the
database
> recovered on my own machine. I sent the MDF and Log files to the client
so
> he could stop SQL Server, copy the files and then start SQL Server again.
> Now I can't get into SQL Server at all - it keeps telling me SQL Server
does
> not exist or access denied. I tried to delete the files that I copied
(after
> shutting down SQL Server) but it didn't work - on startup I still can't
> access the SQL Server with any of the client tools. HELP!
>
|||Stopping the server, copying the files then starting was probably not a good
idea.
If you had the database on your machine then sending a backup and gettig the
client to restore would have been a better option.
Check the sql server logs and application logs - you will probably see a
message to say what has happenned. It sounds like he has corrupted master,
model or done something to change the path of the system databases.
This is probably recoverable but you might be better off re-installing sql
server and attaching all the databases (try ttaching on another server first
to check integrity).
You then might want to look at your backup strategy in case this happens
again.

HELP - problem after copying MDF and Log files

I had a problem where a log file was deleted. I managed to get the databas
e
recovered on my own machine. I sent the MDF and Log files to the client so
he could stop SQL Server, copy the files and then start SQL Server again.
Now I can't get into SQL Server at all - it keeps telling me SQL Server doe
s
not exist or access denied. I tried to delete the files that I copied (afte
r
shutting down SQL Server) but it didn't work - on startup I still can't
access the SQL Server with any of the client tools. HELP!Which database was the log lost for? As long as it was not master or model
you may be able to use sp_attach_single_file_db.
Check if SQL Server is running.
If you did it to master or model, you have messed up the server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"claire" <claire@.discussions.microsoft.com> wrote in message
news:AE9EC5D3-724A-4480-8367-D85855839152@.microsoft.com...
> I had a problem where a log file was deleted. I managed to get the
database
> recovered on my own machine. I sent the MDF and Log files to the client
so
> he could stop SQL Server, copy the files and then start SQL Server again.
> Now I can't get into SQL Server at all - it keeps telling me SQL Server
does
> not exist or access denied. I tried to delete the files that I copied
(after
> shutting down SQL Server) but it didn't work - on startup I still can't
> access the SQL Server with any of the client tools. HELP!
>|||Stopping the server, copying the files then starting was probably not a good
idea.
If you had the database on your machine then sending a backup and gettig the
client to restore would have been a better option.
Check the sql server logs and application logs - you will probably see a
message to say what has happenned. It sounds like he has corrupted master,
model or done something to change the path of the system databases.
This is probably recoverable but you might be better off re-installing sql
server and attaching all the databases (try ttaching on another server first
to check integrity).
You then might want to look at your backup strategy in case this happens
again.