Viewing 15 posts - 5,431 through 5,445 (of 6,583 total)
That really depends upon your business, but what would happen if your boss came to you and said that you need to restore the system back to yesterday at 8:50pm,...
March 23, 2009 at 3:09 pm
Are you sure you did not upgrade the third 05 instance to 08?
Have you verified that the databases in the 08 instance that you are seeing are the same files...
March 23, 2009 at 2:44 pm
You supplied the original query with the column defined as [date]. If you don't have that column available, what do you want the [date] column to be?
I am guessing...
March 23, 2009 at 2:29 pm
Also, you can add a backup log operation (full recovery) or checkpoint (simple recovery) for each iteration to reduce growing the transaction log too much.
March 23, 2009 at 2:25 pm
I don't think the first query is working the way you think it is. By including in the where clause any column from the tables you have left...
March 23, 2009 at 2:20 pm
Read the article I link to in my signature to find out how to post your question so it can be answered better/faster. What you are looking for is...
March 23, 2009 at 1:57 pm
In addition to what Steve has outlined, you are going to have to disable/drop foreign keys before you can recreate the tables. And, don't forget to script the indexes...
March 23, 2009 at 12:15 pm
mgrammer (3/23/2009)
Even though I still have the tables stored on our SQL 2000...
March 23, 2009 at 11:44 am
Yes - it does seem to be related to SQL Server 2000. I just tried with one of my 2000 boxes and was prompted every time I opened a...
March 23, 2009 at 11:12 am
mgrammer (3/23/2009)
I went ahead and ran that statement. I'm assuming that will prevent any future tables from being marked as system, but unfortunately the existing tables did not...
March 23, 2009 at 10:03 am
John (3/23/2009)
March 23, 2009 at 10:00 am
If disk-space isn't as big an issue, and 1 hour data-loss is acceptable, is it worth simply just running a differential backup every hour and leaving it at that?
We...
March 23, 2009 at 9:51 am
steve dassin (3/22/2009)
--------------------------------------------------------------------------------
I'm not saying sql is flawed. I'm saying sql is flawed when it comes to application development.
I hear this from lots of people and I ask them the...
March 22, 2009 at 7:30 pm
JamesNZ (3/22/2009)
March 22, 2009 at 6:43 pm
Viewing 15 posts - 5,431 through 5,445 (of 6,583 total)