Viewing 15 posts - 31 through 45 (of 469 total)
subs99 (1/22/2010)
And then Microsoft warns over and over that you really don't have any backups unless you TEST YOUR BACKUPS! Wow, now that's a project! Does everyone actually test their...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 22, 2010 at 3:15 pm
Your best bet is to search internet to get an idea of DR and its importance. But, the actual DR will be specific to your companies needs.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 22, 2010 at 3:05 pm
dtutil:
You can use the dtutil command prompt utility to manage existing packages at the command prompt. You can access packages that are stored in the SQL Server msdb database, the...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 22, 2010 at 3:02 pm
run the script below to find any open transactions that could be the culprit...
dbcc opentran('tempdb')
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 21, 2010 at 8:43 pm
I guess if it were a permissions issue then this job would never run. It could either be a network issue or a process accessing your disk at the same...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 2:31 pm
yay..:cool:
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 2:24 pm
It looks to be an issue with cross database chaining..to fix it you will need to run the script below on both databases:
ALTER DATABASE db SET DB_CHAINING ON
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 2:18 pm
Then just rename or delete the VS folder from the below path...
'C:\Documents and Settings\%username%\Application Data\Microsoft\VisualStudio'
Hope this helps...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 1:39 pm
Did you have SSAS or SSRS installed too?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 1:34 pm
I concur with Gail on not restarting the server to avoid having a Corrupt database in Suspect mode unless I am sure that it is only a hardware issue and...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 1:25 pm
You need to locate the registry key for the old installation and remove it before proceeding with the new install...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 1:18 pm
Are the databases on the two different servers owned by the same login?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 1:16 pm
You can easily script the BACKUP or RESTORE statement from a Backup Database/Restore Database dialog. Analysis Services 2005 even allows you to encrypt and compress backup files. Both backup and...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 1:09 pm
Can you run the query below and see the sizes then...
DBCC updateusage(myDB)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 1:06 pm
mohammed moinudheen (1/19/2010)
Due to some reason, connections continued to persist on this database because of which I couldn't restore.
To overcome this,...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 20, 2010 at 7:25 am
Viewing 15 posts - 31 through 45 (of 469 total)