Forum Replies Created
Viewing 15 posts - 406 through 420 (of 824 total)
-
RE: Master DB restore
Yes, you can restore msdb without restoring master and that is exactly what I have done for DR purposes. msdb contains all the jobs, dts packages and backup history among other...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Linked Servers
...and this one
http://support.microsoft.com/default.aspx?scid=kb;en-us;280106
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Adding a column to a specific place...
Actually, trying to insert a column in a specific order is indicative of a problem. There should be no meaningful ordering of either columns or rows in a relational table.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Master DB restore
I have generally found that for DR purposes it isn't necessary to restore the master db to the target server, in fact it usually just causes problems. The only thing...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Cannot shrink database after restore to test server
The WITH REPLACE option merely tells SQL to overwrite any existing files of the same name with what is in the backup. The DBCC SHRINKFILE allows you to "resize" the...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: how to check msdtc network connectivity in windows 2000 server
check out http://support.microsoft.com/default.aspx?scid=kb;en-us;306843&sd=tech
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Four Rules for NULLs
"...flawed practice of using special values"? And NULL isn't a special value? OK, by definition, NULL isn't a value at all, it is more accurate to say that it is...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Hello i have a problem with my system of CRM called Onyx
It sounds like you need to call ONYX for support.
To answer your question about SELECT vs. PRINT. SELECT returns a record set to the client (unless it is being...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Optimizing Cursor Performance
Tyler, I had a chance to check this out and you are absolutely correct. I'll let Steve Jones know.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: how to eliminate a cursor
I fully agree with the cursors are bad mentality, but in this case you don't have much of a choice. About the only other option is to create dynamic sql...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Cannot shrink database after restore to test server
But I thought Oracle was UNBREAKABLE?!>!#@(*&$!
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Cannot shrink database after restore to test server
I'm not sure why the shrink is hanging, 20GB isn't that big and shouldn't take that long. However if you want to shrink the database to a size smaller than...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Data file (.ndf) Lost in Action... Recovery needed
You will not be able to restore the database without all of its data files. A log file can be rebuilt assuming that the database was shut down or detached...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: SHRINKDB and READ UNCOMMITTED
That's an interesting one, but I think I have a theory about what's going on.
The shrink operation would have to place locks and latches on the pages that it is re-arranging, and...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Restore from UNC path
Yes, backups can run from UNC paths.
Your issue is almost certainly due to a permissions issue. If you can see that directory from the server in question that doesn't...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 15 posts - 406 through 420 (of 824 total)