Viewing 15 posts - 20,386 through 20,400 (of 26,484 total)
There are options you need to select in Enterprise Manager (I believe, its been a long time since I used it) that will allow you to include those in your...
June 18, 2009 at 3:31 am
In SQL Server 2000 you can either roll your own backup maintenance plans using stored procedures run at scheduled times using SQL Agent jobs, or you can use maintenance plans...
June 18, 2009 at 3:28 am
ps (6/18/2009)
hi_abhay78 (6/18/2009)
Why to apply so many differential backups when one would suffice 🙂
He's restoring to the reporting server everyday morning with diff backup...
log shipping would have been a better...
June 18, 2009 at 3:18 am
Since you are running your production database using the simple recovery model you don't have the option of taking transaction log backups.
Try restoring your database as follows and see if...
June 18, 2009 at 12:11 am
You may also want to read Books Online (BOL, the SQL Server Help System), as you may be able to use the STANDBY clause instead of the RECOVERY clause with...
June 17, 2009 at 9:54 pm
What is the recovery model of your PRODUCTION database? If it is using the Full Recovery model, you might want to look at using log shipping to keep you...
June 17, 2009 at 9:49 pm
Once you do a RESTORE ... WITH RECOVERY, no more backup files may be applied. If you are restoring this database daily for reporting using your current process, you...
June 17, 2009 at 9:47 pm
NEI. Not Enough Information. What exactly are you trying to accomplish? Is the mirror database used for any purpose during the day?
June 17, 2009 at 9:32 pm
First, why such a requirement? Second, I am not aware of any utility to accomplish this conversion. Third, if you rewrite the stored procedures as multi-lined table valued...
June 17, 2009 at 9:26 pm
Why would you want to eliminate policy_number? That is what relates the data together? It looks like if forms the Foreign Key relationships you need between the tables.
June 17, 2009 at 9:19 pm
isa_sey (6/17/2009)
We restored our full backup WITH NORECOVERY, it was successful. then we restored our first differential backup WITH RECOVERY, it was also successful. But on our attemp...
June 17, 2009 at 9:10 pm
Flip the order of the tables in the trigger and the the update occurs properly based on the clustered index on the table being updated even with the force plan....
June 17, 2009 at 7:02 am
However, you are forcing the order of the update by INSERTED, not the table you are updating. So, are you really breaking the quirky update that allows for a...
June 17, 2009 at 6:55 am
You know what they say, read the whole question.
June 17, 2009 at 6:47 am
Paul,
Check out the difference between the two pieces of code below and their behaviour:
CREATE TABLE dbo.[976231EF-DA13-4A8A-91DC-7D8931A2C14B]
(
row_id INT...
June 17, 2009 at 6:25 am
Viewing 15 posts - 20,386 through 20,400 (of 26,484 total)