Viewing 15 posts - 6,181 through 6,195 (of 9,241 total)
once you complete the restore and upgrade from 2000 to 2008 you must run the following against the database
DBCC UPDATEUSAGE
Followed by
DBCC CHECKDB WITH DATA_PURITY
Then go rebuild all your indexes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 20, 2011 at 11:08 am
as already mentioned, see my article at this link[/url] for more info on setting up and using mount points for SQL Server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 20, 2011 at 11:02 am
khandelwal_arun (12/20/2011)
Hello,Can you please help me out how I remove log_reuse_wait_desc = Replication to Active_Transcation.
Thanks in advanace for help me out ...
Regards,
Are you taking regular backups of the publication\distribution databases?
Is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 20, 2011 at 9:50 am
Ignacio A. Salom Rangel (12/20/2011)
Maybe you could blog about it!
See my link above 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 20, 2011 at 1:34 am
check the event log for any messages.
Take the group offline and then bring the resources up 1 at a time in the following sequence
1/ IP address
2/ Network name
3/...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2011 at 7:52 am
a replicated database cannot really be considered a true 100% copy of your original database, what if a connection needs to use an object you have not replicated to the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2011 at 6:20 am
JohnnyDBA (12/16/2011)
Microsoft believes the root cause is an issue with the mount point configuration.
I'd be inclined to agree.
Where are your disks presented from for the mounted volumes are they...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2011 at 6:12 am
yes, it is a change to the registry. The cluster service should replicate the key change to all nodes required
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2011 at 2:45 pm
for mounted volumes use the following
wmic volume get name, "Free Space", capacity
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2011 at 2:43 pm
Transaction log backups are an important part of log shipping. Digest the info in books online and post back if you're still stuck.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2011 at 2:38 pm
chopperGuy (12/16/2011)
Problem we are facing is that copy process...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2011 at 2:26 pm
I would of thought you would see a message indicating that the master key already exists, firstly check the results of
select * from sys.symmetric_keys
If you have more than 1...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2011 at 2:19 pm
Jeffrey Williams 3188 (12/13/2011)
Or - look at creating a Powershell script instead of VB script. That can also be called from an agent job directly.
Good call 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2011 at 1:42 am
This is an ideal scenario for creating package configurations. when creating a configuration elect to use SQL Server roles and security. Export your chosen connection string objects and they are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2011 at 1:40 am
Sean Grebey-262535 (12/13/2011)
Shrink finished after about 2 hours.
How much free space did you leave?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 2:36 pm
Viewing 15 posts - 6,181 through 6,195 (of 9,241 total)