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 ! Suddenly, terribly slow SQLServer Enterprise Manager

Hi,
I am using SQLServer on my development laptop, and it's running without
any problems since at least 6 or 7 months. Suddenly, since yesterday,
when I start the Entreprise Manager, it takes absolute AGES (minutes,
with a very intensive disk activity) until it shows the console root,
and each click on a table takes again ages until the rows are shown.
Even paging takes now 10 times longer as before. My DB is very snmall,
something like 50,000 rows in total max. A double click on the table
icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A
click on the "Run" icon in the tool bar takes more than 10 seconds to
complete, to show 40-50 rows !
I have reorganized the DB, but that does not help at all for the
performance.
I noticed that the log file is 76 Megabytes whereas the DB after
shrinking is only 8 Meg. I have done a backup of the log file, but it is
only a ridicule 196 KBytes, and the live log is just as big as before !
The very strange thing is that, if I log as another user on my laptop,
then I have the normal speed in Enterprise Manager. How is that possible ?
What's going on ? Why suddenly, where I can't remember having done
anything special these last days. And more importantly, how do I get
back to the previous status, where everything was real quick ? I just
can't work properly anymore if every single click is taking minutes !!!
Thanks for help.
Bernard
Sound like someone has turned on ODBC tracing.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:%230mAl35kFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am using SQLServer on my development laptop, and it's running without any problems since at
> least 6 or 7 months. Suddenly, since yesterday, when I start the Entreprise Manager, it takes
> absolute AGES (minutes, with a very intensive disk activity) until it shows the console root, and
> each click on a table takes again ages until the rows are shown. Even paging takes now 10 times
> longer as before. My DB is very snmall, something like 50,000 rows in total max. A double click on
> the table icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A click on the
> "Run" icon in the tool bar takes more than 10 seconds to complete, to show 40-50 rows !
> I have reorganized the DB, but that does not help at all for the performance.
> I noticed that the log file is 76 Megabytes whereas the DB after shrinking is only 8 Meg. I have
> done a backup of the log file, but it is only a ridicule 196 KBytes, and the live log is just as
> big as before !
> The very strange thing is that, if I log as another user on my laptop, then I have the normal
> speed in Enterprise Manager. How is that possible ?
> What's going on ? Why suddenly, where I can't remember having done anything special these last
> days. And more importantly, how do I get back to the previous status, where everything was real
> quick ? I just can't work properly anymore if every single click is taking minutes !!!
> Thanks for help.
> Bernard
|||THANK YOU ! I DID turn it on, and did not see any log at all coming up,
so I thought it had not worked and totally forgot about it !
Yes, now my Enterprise Manager is back to normal.
You made my day ! Sometimes, it's so simple...
Ah, what a relief it is...
And what about my <database>_Log.LDF file ? How do I get rid of/truncate
it ?
Regards, and thanks again.
Bernard
Tibor Karaszi wrote:
> Sound like someone has turned on ODBC tracing.
>
|||> And what about my <database>_Log.LDF file ? How do I get rid of/truncate it ?
The ldf file is a part of the database. You can't get rid of it. If you consider it being too large,
then you should read in Books Online about recovery model and decide whether or not you want to do
regular transaction log backups. If you have had the db in full recovery model and not been doing
regular transaction log backups and have a very large ldf file, you can shrink it using DBCC
SHRINKFILE. Also check out http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:OKNqi36kFHA.2472@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> THANK YOU ! I DID turn it on, and did not see any log at all coming up, so I thought it had not
> worked and totally forgot about it !
> Yes, now my Enterprise Manager is back to normal.
> You made my day ! Sometimes, it's so simple...
> Ah, what a relief it is...
> And what about my <database>_Log.LDF file ? How do I get rid of/truncate it ?
> Regards, and thanks again.
> Bernard
>
> Tibor Karaszi wrote:

HELP ! Suddenly, terribly slow SQLServer Enterprise Manager

Hi,
I am using SQLServer on my development laptop, and it's running without
any problems since at least 6 or 7 months. Suddenly, since yesterday,
when I start the Entreprise Manager, it takes absolute AGES (minutes,
with a very intensive disk activity) until it shows the console root,
and each click on a table takes again ages until the rows are shown.
Even paging takes now 10 times longer as before. My DB is very snmall,
something like 50,000 rows in total max. A double click on the table
icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A
click on the "Run" icon in the tool bar takes more than 10 seconds to
complete, to show 40-50 rows !
I have reorganized the DB, but that does not help at all for the
performance.
I noticed that the log file is 76 Megabytes whereas the DB after
shrinking is only 8 Meg. I have done a backup of the log file, but it is
only a ridicule 196 KBytes, and the live log is just as big as before !
The very strange thing is that, if I log as another user on my laptop,
then I have the normal speed in Enterprise Manager. How is that possible ?
What's going on ? Why suddenly, where I can't remember having done
anything special these last days. And more importantly, how do I get
back to the previous status, where everything was real quick ? I just
can't work properly anymore if every single click is taking minutes !!!
Thanks for help.
BernardSound like someone has turned on ODBC tracing.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:%230mAl35kFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am using SQLServer on my development laptop, and it's running without any problems since at
> least 6 or 7 months. Suddenly, since yesterday, when I start the Entreprise Manager, it takes
> absolute AGES (minutes, with a very intensive disk activity) until it shows the console root, and
> each click on a table takes again ages until the rows are shown. Even paging takes now 10 times
> longer as before. My DB is very snmall, something like 50,000 rows in total max. A double click on
> the table icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A click on the
> "Run" icon in the tool bar takes more than 10 seconds to complete, to show 40-50 rows !
> I have reorganized the DB, but that does not help at all for the performance.
> I noticed that the log file is 76 Megabytes whereas the DB after shrinking is only 8 Meg. I have
> done a backup of the log file, but it is only a ridicule 196 KBytes, and the live log is just as
> big as before !
> The very strange thing is that, if I log as another user on my laptop, then I have the normal
> speed in Enterprise Manager. How is that possible ?
> What's going on ? Why suddenly, where I can't remember having done anything special these last
> days. And more importantly, how do I get back to the previous status, where everything was real
> quick ? I just can't work properly anymore if every single click is taking minutes !!!
> Thanks for help.
> Bernard|||THANK YOU ! I DID turn it on, and did not see any log at all coming up,
so I thought it had not worked and totally forgot about it !
Yes, now my Enterprise Manager is back to normal.
You made my day ! Sometimes, it's so simple...
Ah, what a relief it is...
And what about my <database>_Log.LDF file ? How do I get rid of/truncate
it ?
Regards, and thanks again.
Bernard
Tibor Karaszi wrote:
> Sound like someone has turned on ODBC tracing.
>|||> And what about my <database>_Log.LDF file ? How do I get rid of/truncate it ?
The ldf file is a part of the database. You can't get rid of it. If you consider it being too large,
then you should read in Books Online about recovery model and decide whether or not you want to do
regular transaction log backups. If you have had the db in full recovery model and not been doing
regular transaction log backups and have a very large ldf file, you can shrink it using DBCC
SHRINKFILE. Also check out http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:OKNqi36kFHA.2472@.TK2MSFTNGP15.phx.gbl...
> THANK YOU ! I DID turn it on, and did not see any log at all coming up, so I thought it had not
> worked and totally forgot about it !
> Yes, now my Enterprise Manager is back to normal.
> You made my day ! Sometimes, it's so simple...
> Ah, what a relief it is...
> And what about my <database>_Log.LDF file ? How do I get rid of/truncate it ?
> Regards, and thanks again.
> Bernard
>
> Tibor Karaszi wrote:
>> Sound like someone has turned on ODBC tracing.

HELP ! Suddenly, terribly slow SQLServer Enterprise Manager

Hi,
I am using SQLServer on my development laptop, and it's running without
any problems since at least 6 or 7 months. Suddenly, since yesterday,
when I start the Entreprise Manager, it takes absolute AGES (minutes,
with a very intensive disk activity) until it shows the console root,
and each click on a table takes again ages until the rows are shown.
Even paging takes now 10 times longer as before. My DB is very snmall,
something like 50,000 rows in total max. A double click on the table
icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A
click on the "Run" icon in the tool bar takes more than 10 seconds to
complete, to show 40-50 rows !
I have reorganized the DB, but that does not help at all for the
performance.
I noticed that the log file is 76 Megabytes whereas the DB after
shrinking is only 8 Meg. I have done a backup of the log file, but it is
only a ridicule 196 KBytes, and the live log is just as big as before !
The very strange thing is that, if I log as another user on my laptop,
then I have the normal speed in Enterprise Manager. How is that possible ?
What's going on ? Why suddenly, where I can't remember having done
anything special these last days. And more importantly, how do I get
back to the previous status, where everything was real quick ? I just
can't work properly anymore if every single click is taking minutes !!!
Thanks for help.
BernardSound like someone has turned on ODBC tracing.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:%230mAl35kFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am using SQLServer on my development laptop, and it's running without an
y problems since at
> least 6 or 7 months. Suddenly, since yesterday, when I start the Entrepris
e Manager, it takes
> absolute AGES (minutes, with a very intensive disk activity) until it show
s the console root, and
> each click on a table takes again ages until the rows are shown. Even pagi
ng takes now 10 times
> longer as before. My DB is very snmall, something like 50,000 rows in tota
l max. A double click on
> the table icon of the largest table (20,000 rows) takes 2 MINUTES to compl
ete ! A click on the
> "Run" icon in the tool bar takes more than 10 seconds to complete, to show
40-50 rows !
> I have reorganized the DB, but that does not help at all for the performan
ce.
> I noticed that the log file is 76 Megabytes whereas the DB after shrinking
is only 8 Meg. I have
> done a backup of the log file, but it is only a ridicule 196 KBytes, and t
he live log is just as
> big as before !
> The very strange thing is that, if I log as another user on my laptop, the
n I have the normal
> speed in Enterprise Manager. How is that possible ?
> What's going on ? Why suddenly, where I can't remember having done anythin
g special these last
> days. And more importantly, how do I get back to the previous status, wher
e everything was real
> quick ? I just can't work properly anymore if every single click is taking
minutes !!!
> Thanks for help.
> Bernard|||THANK YOU ! I DID turn it on, and did not see any log at all coming up,
so I thought it had not worked and totally forgot about it !
Yes, now my Enterprise Manager is back to normal.
You made my day ! Sometimes, it's so simple...
Ah, what a relief it is...
And what about my <database>_Log.LDF file ? How do I get rid of/truncate
it ?
Regards, and thanks again.
Bernard
Tibor Karaszi wrote:
> Sound like someone has turned on ODBC tracing.
>|||> And what about my <database>_Log.LDF file ? How do I get rid of/truncate i
t ?
The ldf file is a part of the database. You can't get rid of it. If you cons
ider it being too large,
then you should read in Books Online about recovery model and decide whether
or not you want to do
regular transaction log backups. If you have had the db in full recovery mod
el and not been doing
regular transaction log backups and have a very large ldf file, you can shri
nk it using DBCC
SHRINKFILE. Also check out http://www.karaszi.com/SQLServer/in...ver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:OKNqi36kFHA.2472@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> THANK YOU ! I DID turn it on, and did not see any log at all coming up, so
I thought it had not
> worked and totally forgot about it !
> Yes, now my Enterprise Manager is back to normal.
> You made my day ! Sometimes, it's so simple...
> Ah, what a relief it is...
> And what about my <database>_Log.LDF file ? How do I get rid of/truncate i
t ?
> Regards, and thanks again.
> Bernard
>
> Tibor Karaszi wrote:

HELP - Slow Connection establishment on Windows XP

Hi All,

Just bought a new laptop, everything fine EXCEPT when a java program I have written tries to get a connection to an SQL server database. It gets the connection no problem but its about three times slower than on my desktop machine to the same server.

The laptop is running windows XP Home, and I am connecting to an SQL server database.

I have absolutely no IDEA why it takes three times longer on a machine which is 10 times faster than my desktop. My desktop is running windows NT.

Any hints would be most appreciated.

thanks.Those 56k modems can be a dog...

;-)

How are you connecting to sql server..can you show us the connection string?|||its ok, the problem was that I had to put the sql server machine in the hosts file in windows\system32\drivers\etc

i.e. 123.123.123.123 servername.

thanks anyway.

Help - Error: Unable to open the physical file

Hi, I've just finished creating my first ASP.NET website. I created it on my laptop and it works perfectly, but I'm having some problems deploying it to my web server (PC).
The site works ok, but when I try to log in to my client area, I get this error:

"Unable to open the physical file "c:\inetpub\wwwroot\ONeillStrata\App_Data\aspnetdb.mdf". Operating system error 5: "5(Access is denied.)".
An attempt to attach an auto-named database for file c:\inetpub\wwwroot\ONeillStrata\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."

I've searched far and wide for a solution and have read many articles, but none seem to be able to fix my problem. I've tried using that SEUtil tool, but that didn't work, I've made sure the App_Data directory on the web server isn't read only (the read-only checkbox isn't ticked, but it DOES have that little green square which I can't get rid of), I've assigned the ASPNET user as a db owner and that didn't work and I've manually attached the database to the web server's instance of SQL Express 2005.
When I launch the solution in VS2005 on the web server, I can browse through the database and see the tables and data etc, but when I try to run the application, I get that message above...

Surely it shouldn't be this hard to get it going?
Any help would be massively appreciated.

Hi,

It seems that the physical file location of the aspnetdb.mdf is wrong.

Please open your IIS, right click on your default web site,and click on the properties, change to the ASP.NET tab, edit configurations.Then you can see the LocalSqlServer string listed there, change the string into the following:data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true.

Thanks.