If the production database, MyDB, resides in F:\SQLData on the production server and you restore the backup of this database to a test server without using the MOVE clause, it...

Please remember we are volunteers and we answer...

May I ask why you started a new thread for what looks like essentially the same problem?

Eugene Elutin (3/19/2012)

---

CELKO (3/19/2012)

---

The ISO-11179 is one....

Also, if you have separate servers for production and test, how does this even come into play:

I just do not want to restore a production database backup over top...

On your test server, do you have a directory f:\sqldata or is it only F:\testsqldata? If you don't have the f:\sqldata and you don't include the MOVE clause, the...

If you haven't already, I'd start looking at SQL Server 2012 and Always On. It provides the benefits of both clustering and database mirroring.

I think it depends on the applications you are running as well. SQL Server 2012 is just coming out. Many 3rd party software packages may not support SQL...

pollen

Actually, I would use a calendar table and do a left join from it to the dates in the list. The null values can be converted to 0 using...

kevinsql7 (3/19/2012)

---

SSCOACH,

"You will need to use both the MOVE and REPLACE if you want the database files in the same location on the test server. "

My concern is I do...

You will need to use both the MOVE and REPLACE if you want the database files in the same location on the test server.

The output given is correct for the data type involved, you are sorting a string. Based solely on your sample data, one way to sort it is as follows:

declare...

I have SSMS set to replace tabs with spaces. That way I use a tab to indent but it actually uses spaces.

If I need to change an indent on...

Our point is that everyone has their own standard.

I worked with three other people at one company and each of us formatted code differently. Three of us had no...