Viewing 15 posts - 1,156 through 1,170 (of 1,319 total)
Either ask (and hope for correct answers) or investigate yourself:
1) Backup strategy - full, logs, differentials - are they working and have they been tested?
2) Does backup strategy fit user...
-- You can't be late until you show up.
May 9, 2008 at 7:30 am
I totally agree with Grant and Steve. I restore to a full test environment, log in using the various apps and do a general look around. About twice a year,...
-- You can't be late until you show up.
May 8, 2008 at 1:07 pm
Indexes are good, checked that when all this started (and since). It's amazing, when I run the original, it starts locking/blocking like crazy but when I run the copy of...
-- You can't be late until you show up.
May 8, 2008 at 7:02 am
Not sure what you mean by "copy of the "good" plan", the script of the proc? If so, I have backups and a good copy of the database (from 4/22)...
-- You can't be late until you show up.
May 7, 2008 at 3:24 pm
I've used it for years as well, without issue. I do check the accuracy of my backups from time to time, just to be sure. I've heard all the stories...
-- You can't be late until you show up.
May 7, 2008 at 2:22 pm
Microsoft has this script as a recommendation for transferring logins:
----- Begin Script, Create sp_help_revlogin procedure -----
USE master
GO
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL
DROP PROCEDURE sp_hexadecimal
GO
CREATE PROCEDURE sp_hexadecimal
...
-- You can't be late until you show up.
May 2, 2008 at 10:00 am
Personally, if I am modifying a production database, I ALWAYS take a full backup prior to the execution of the scripts. What is the rational to "I dont want to...
-- You can't be late until you show up.
May 2, 2008 at 8:57 am
What do you mean that recovering the backups failed miserably? What errors are you receiving or issues are you facing? I agree, I haven't used 6.5 in years but I...
-- You can't be late until you show up.
May 1, 2008 at 9:35 am
See BOL for great examples, but.....
This will create a local temp table for you:
Select * into #newtables from tablename
-- You can't be late until you show up.
May 1, 2008 at 9:26 am
That's what I'm thinking too. For months we had a MP running flawlessly, until someone changed the recovery option of a DB from full to simple. All the other DBs...
-- You can't be late until you show up.
May 1, 2008 at 6:57 am
What does it say in the error log? What recovery mode does this database have (if simple, you cannot backup logs)? What does "and we found that it is because...
-- You can't be late until you show up.
April 30, 2008 at 7:37 am
It may not simply be disk space. It could also be rights to the share (did not know that!) if it says "error not found". I always looked at error...
-- You can't be late until you show up.
April 29, 2008 at 12:00 pm
Vivien, In S2K, if you right-click on the database from EM, select all tasks, select generate scripts then on the option tab, you can script the db, the database options,...
-- You can't be late until you show up.
April 29, 2008 at 11:16 am
ahutchens, I believe you are right! - except it says "Date Last Used" under Add/Remove Programs , which I know is the install date of the sp and hotfix (we...
-- You can't be late until you show up.
April 29, 2008 at 9:45 am
I thought it was a permissions problem so I googled it. Check this out, it might help:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1140586&SiteID=17
-- You can't be late until you show up.
April 28, 2008 at 9:47 am
Viewing 15 posts - 1,156 through 1,170 (of 1,319 total)