Viewing 15 posts - 1,186 through 1,200 (of 1,319 total)
You can also backup the old database and restore it to the new database. Depending on the volume of data, this may be quicker. Just curious, why did you create...
-- You can't be late until you show up.
April 15, 2008 at 7:48 am
Search for files modified on a certain date, asuming you know when the backup was taken. If you specified a file destination without an extension, I do not believe a...
-- You can't be late until you show up.
April 15, 2008 at 7:17 am
As John stated, we're not sure what exactly you are trying to do. To simply view the database and it's contents, a suggestion has already been given. If trying to...
-- You can't be late until you show up.
April 15, 2008 at 7:15 am
Not a lot of info to go on. How much memory is installed on the server? Is there adequate disk space available? What else is running on the server?
Check these...
-- You can't be late until you show up.
April 14, 2008 at 8:23 am
I tend to say "sequel" when talking about the overall environment and SQL when talking about coding. Think I'm simply going to use squeal for both from now on! That'll...
-- You can't be late until you show up.
April 11, 2008 at 9:34 am
And from a referential integrity standpoint, if the identity field is used as a foreign key elsewhere, you're going to have to either issue updates to each of the references...
-- You can't be late until you show up.
April 11, 2008 at 9:08 am
Can you restore the backup on another server and verify that the backup is good?
-- You can't be late until you show up.
April 11, 2008 at 8:44 am
More frequent log backups do not reduce the size of the log but does reduce the amount of data contained within the log. In order to keep the log reasonably...
-- You can't be late until you show up.
April 11, 2008 at 8:43 am
For what? Better NIC cards, better routers, better cables. Kind of an open ended question. Is SQL not returing data quick enough? Could be a poorly written query, slow disks,...
-- You can't be late until you show up.
April 11, 2008 at 8:34 am
It's definitely permissions, either the account doesn't have access to the server or to the particualr share on that server. Check these links.
http://www.microsoft.com/technet/archive/winntas/support/acdenid2.mspx?mfr=true
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2288846&SiteID=17
-- You can't be late until you show up.
April 11, 2008 at 8:23 am
Just a followup. This was on the freeware version of VMWare not ESX as I originally stated. We rolled a different server to ESX about two weeks ago without issue....
-- You can't be late until you show up.
April 10, 2008 at 12:05 pm
What would define a unique row, simply contract? Can you provide table layouts and some sample data? It's not a hard world, just different. Stick around, there's a lot of...
-- You can't be late until you show up.
April 10, 2008 at 11:49 am
I agree with SQLZ. If you want to maintain any amount of control, don't let them run it against production. Give them a daily, refreshed dev environment, have them run...
-- You can't be late until you show up.
April 10, 2008 at 11:43 am
Check this out - a hotfix for sp4. Seems to be what you're experiencing.
http://support.microsoft.com/kb/924664
-- You can't be late until you show up.
April 10, 2008 at 11:25 am
I've never seen Paul harsh. Always professional, always out there helping with very knowledgable advice. When dealing with corruption or other severe issues, I want sound, direct advice on how...
-- You can't be late until you show up.
April 10, 2008 at 10:10 am
Viewing 15 posts - 1,186 through 1,200 (of 1,319 total)