Drop the database HEALTH_DEV and restore production database backup into it with 'move' parameter. For example,RESTORE DATABASE TestDB FROM DISK = 'c:\Northwind.bak' WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf', MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
2004-12-02
2004-11-24
Also, you have almost a 2 minute stoppage of I/O. That's a LONG time.
2004-11-24
In this particular case, the html code is before the text we need and is the same string for each field. This might be as simple as a "trim left" command in the data transformation task. Can someone show me the correct way to use this command? We recently changed database structures and the project […]
2004-11-22
HiIf anyone can perhaps give some tips on dropping and re-creating indexes I woul appreciate it a lot. Is there a specific sequence in which one should drop and re-create the different types indexes?Thanks
2004-11-01
1 reads
There's another thread about this in the Backups forum: http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=142470#bm142884Greg
2004-10-27
This doesn't sound good. I tried doing a Google search on "hang module hungapp" mmc and still not getting very far. The evidence seems to implicate hardware and/or some computer apps. But even if you accept this/these, other than ensuring that all the latest drivers are installed, the advice on solving the problem is a […]
2004-10-11
2 reads
Can you please post the definition for the view?(my guess is that there is an outer join in there..?)/Kenneth
2004-10-04
If you are trying to directly reference the #table it will not work. You will have to do the code inside a stored procedure. The problem is the system looks for an object to verify the columnar paths, etc... and can't because the object doesn't exist.
2004-09-02
I have a DB that is around 250GB that is growing rapidly. It is running on a 4 proc clustered server with EMC SAN for storage. The entire database resides on a single data file within a RAID 5 partition, and as of right now it is performing very well. However, I am wondering if I should create […]
2004-08-13
8 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers